Hi,

Select the range of cells and this assumes A1 is the first cell then
format|Conditional format
Select 'Formula is' and enter the formula

=ISBLANK(A1)
Pick your colour

Click ADD and repeat the above using this formula

=AND(ISNUMBER(A1),A1=0)

Mike

"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