Note: it is not sufficient to use =A1=0 since blank cells will satisfy this
test


I posted the same solution as yourself because I think it's good practice to
eliminate blanks evaluating as 0 but if you evaluate the isblank as the first
condition then =a1=0 is fine as the second

Mike

"Bernard Liengme" wrote:

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