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

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
zero
and returns true). For example, if cell H21
holds a zero, the condition would be true and the cell would have a re

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

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

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