Conditional Formatting for True/False

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

=if(len(trim(H21))=0,False,if(H21=0,True,False))

--
Regards,
Tom Ogilvy


"Phil H." <[email protected]> wrote in message
news:[email protected]...
>
> 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
>