I have the following conditional formatting applied.
What I am doing is checking for sales vs goal and plan. The formulas themselves work. I know this because Row 6 works. It turns green when any of the formulas are true.
What is wrong is that I7 stays green when it is false and then B7 does not change to green when the formula is true.
Here the formula is true:
Does anyone see what I am doing wrong? I deleted the rest of the conditional formatting on the sheet to eliminate the possibility that something else was throwing this off.
Formula 1
=AND(I7>=E8,I7<I8)
Formula 2
=I7>=I8
