Set the default to white, that is not C F.

The non-working formula should be

=AND(AI19-0.2,AI19<0.2,AI19<0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Raj" wrote in message
...
New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work
for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....