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????
=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????