How to format cell using Blank and Conditional Formatting..

[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

 

[Frank Kabel]

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

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