Hey guys- trying to get this thing to work, but, it's just staying white.
Any ideas as to what's wrong with it? I have this inserted in the 'Formula
Is' part of Conditional Formating- obviously without the =Green or =Red
remarks. Any ideas?


=OR(AND(BC2<=100000,BG<=0.7),AND(BC2100000,BC2<=1 40000,BG<=0.75),
AND(BC2140000,BC2<=180000,BG<=0.8), AND(BC2180000,BG<=0.85))
=GREEN

=OR(AND(BC2<=100000,BG0.7),AND(BC2100000,BC2<=14 0000,BG0.75),
AND(BC2140000,BC2<=180000,BG0.8), AND(BC2180000,BG0.85))
=RED


Thank you!
D