Conditional Formatting help....

Hi All,
Background: I have a cell That I'm checking these three conditions against.

B5= 100%, C5 = Blank

Three conditional formats:
=AND((B5-C5)>=1%,($B5-C5)<=9%) (Background=YelloW (91% to 99%))
=AND((B5-C5)>=10%) - (Background =Red (below 90%))
=AND((C5>=B5) - (Background=Green (100% or greater))

Problem: Before any data is entered the cells are all colored red because the value in them is 0 by default. Is there a way to get around this? I would like the user to enter a 0, have the cell check the conditions, and then turn it red. Can this be done?

Thanks for any help!

Use

=AND(C5<>"",B5-C5>=10%) for red

BTW, the last is just

=C5>=B5

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"HellBent" <[email protected]> wrote in
message news:[email protected]...
>
> Hi All,
> Background: I have a cell That I'm checking these three conditions
> against.
>
> B5= 100%, C5 = Blank
>
> Three conditional formats:
> =AND((B5-C5)>=1%,($B5-C5)<=9%) (Background=YelloW (91% to 99%))
> =AND((B5-C5)>=10%) - (Background =Red (below 90%))
> =AND((C5>=B5) - (Background=Green (100% or
> greater))
>
> Problem: Before any data is entered the cells are all colored red
> because the value in them is 0 by default. Is there a way to get around
> this? I would like the user to enter a 0, have the cell check the
> conditions, and then turn it red. Can this be done?
>
> Thanks for any help!
>
>
> --
> HellBent
> ------------------------------------------------------------------------
> HellBent's Profile:
http://www.excelforum.com/member.php...o&userid=35341
> View this thread: http://www.excelforum.com/showthread...hreadid=551114
>

Hi Bob,
I tried that but it's still red. If I change the " " to a 0 then the cell will turn white. Am I right that if a cell is empty then it equals 0?

Thanks for getting back so fast!

I didn't say " ", I said "", they are different.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"HellBent" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Bob,
> I tried that but it's still red. If I change the " " to a 0 then the
> cell will turn white. Am I right that if a cell is empty then it equals
> 0?
>
> Thanks for getting back so fast!
>
>
> --
> HellBent
> ------------------------------------------------------------------------
> HellBent's Profile:
http://www.excelforum.com/member.php...o&userid=35341
> View this thread: http://www.excelforum.com/showthread...hreadid=551114
>

Ahhhhh! My bad Bob! Thanks again for your help!!!!!!!