Remove Border

[edwardpestian]

I have three cells (E5, E6 and G6). The cells have border around them. I would like the border to be removed when the cells have data in them, and show the border when the cells do not have data in them.

Thanks in advance.

EP

 

[SkipVought]

Hi,

Tip: Turn on your macro recorder and remove/add your border.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[CaptainD]

Can't you use "Conditional formating"?

 

[edwardpestian]

Condition formatting worked great. Thanks for the tip.

EP