Forum Discussion
Conditional Formatting
I want to change cell A3 to yellow when remaining balance value reaches 85% of allotted value in cell D3. The cell is green when under budget and goes to red when over budget.
But 85% is, itself, "under budget." So unless you're talking of different cells with the green-yellow-red sequence, you have conflicting criteria here.
Is it possible for you to depict things a bit more fully? How have you spelled out the conditional formatting rules that ARE working for the Green and Red conditions?
It may be that the solution is to have more precisely defined conditions
- green when less than or equal to 84.999%
- yellow when between 85 and 99.999%
- red when >100%
Not sure how it has changed or is harder but you can create 2-3 rules each to color cell A3 based on formula of D3 (you can use 2 rules by setting the fill color to 1 color and use 2 rules to change the color).
Another option is to use a single 'icon sets' to create green, yellow, red dots (or arrows) based on ranges as follows: