Conditional Formatting help....

[HellBent]

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!

 

[Bob Phillips]

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]

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

Thanks for getting back so fast

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[HellBent]

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