Using all three conditions for green/yellow/red background formats. In

the red condition I need a formula returning a true condition for a
zero, and false when the cell is blank. (Excel treats the blank as a
zero
and returns true). For example, if cell H21
holds a zero, the condition would be true and the cell would have a red

background; if H21 was blank, a false condition would exist and no
conditional formatting would be applied - in other words, whatever the

default cell background is, would prevail. What would this formula be?


--
Phil H.
------------------------------------------------------------------------
Phil H.'s Profile: http://www.hightechtalks.com/m229
View this thread: http://www.hightechtalks.com/t2280567