Conditional Formatting Issue

[LindaDuhe]

I have an issue regarding conditional formatting. I have three conditions (formulas) that present the figures colour coded. I have the following three (simple) formula's:
=IF(G7<90%;E7;0) - pattern = RED
=IF(G7>99,9%;E7;0) - pattern = GREEN
=IF(G7>90%;E7;IF(G7<100%;E7;0)) - pattern = ORANGE

Now the problem I have, is that if my G column shows as the result 0%, conditional formatting does not appear to work. The E column should turn RED (because <90%), however when it is 0% it does not work.

Any way to fix this????

 

[Fazza]

Hi, Linda.

Maybe you want conditions like below?

HTH, Fazza

=G7<0
=G7>99%
=AND(G7>90%,G7<1)

 

[LindaDuhe]

I need three conditions that say:
>99.9%
between 90% and 99.9%
<90%

Since you can only have 3 formula'/conditions I cannot change this. Even when you try inputting something like =0%, it does not work....

 

[Andrew Poulsom]

Try:

=AND(G7>0,G7<90%) Red
=G7>99.9% Green
=AND(G7>90%,G7<100%) Orange