How to format cell using Blank and Conditional Formatting..

T

Tim Harding

I have a spreadhseet which has conditional formatting

so that if a cell is less than a target it goes red and if
higher goes green, however if the cell is blank how do I
get it to stay white....?

Thanks

Tim
 
F

Frank Kabel

Hi
use the following formulas in the conditional format dialog:
=(A1>value)*(A1<>"")

and
=(A1<value)*(A1<>"")
 
Top