Change the condition to Formula Is and use the following formula to determine
if a cell is blank:

=ISBLANK(A1)

Then select the formatting for that condition.

Add a second condition and use the following formula for 0 (zero) values:

=A1=0

Then select the formatting for that condition.

Change the cell address A1 accordingly.
--
Kevin Backmann


"Stig - tame racing driver" wrote:

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