Conditional Formatting Boarders

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
This is probably easy but I need help with it, I have this formula in a cell =IF(C21>0,C21,"") If it returns "" ( Blank ) nothing I dont want a boarder around it, if it returnes any data I want a boarder. I tried conditional formatting but it seems to see the formula as not blank and still puts a boarder around it even if the formula returns a blank cell.

Thanks for your help
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Assuming your cell is D21 use CF, "formula is"

=D21<>""

and set borders as required
 

Watch MrExcel Video

Forum statistics

Threads
1,118,455
Messages
5,572,223
Members
412,448
Latest member
ManuW
Top