Conditional Formatting Boarders

[jcaptchaos2]

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

 

[barry houdini]

Assuming your cell is D21 use CF, "formula is"

=D21<>""

and set borders as required

 

[jcaptchaos2]

Thanks Barry works perfect