Conditional Formatting
 

I entered a conditional format for a row which shaded all cells equal to
zero. However, this also shades cells which are empty. How do you omit empty
cells from this conditional format? Thanks!

Conditional Formatting
 

Use:

Conditional Formatting
Formula Is: =AND(ISNUMBER(A1),A1=0)

Biff

"Onfoot418" wrote in message
...
I entered a conditional format for a row which shaded all cells equal to
zero. However, this also shades cells which are empty. How do you omit
empty
cells from this conditional format? Thanks!