Thank you ........

"Bernard Liengme" wrote in message
...
I selected a range A1:C5; some of these cells were blank others had 0 in
them
In CF dialog I used these two formulas
=ISBLANK(A1)..... green fill
=AND(ISNUMBER(A1),A1=0)... red fill
This gave me the result you wished to have
Note: it is not sufficient to use =A1=0 since blank cells will satisfy
this test
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Stig - tame racing driver" wrote in
message ...
Help

Using the conditional formatting tool is it possible to have a colour for
cells with 0 and a colour for blank cells

Thanking you