Conditional Formatting

Lvalencia74 

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%