Changing font color in one cell when % in another cell changes [Solved/Closed]

Ask a question abqjukebox 1Posts Friday April 22, 2016Registration date April 22, 2016 Last seen - Last answered on Apr 22, 2016 at 06:13 PM by Ambucias

I have a balance in B1 of what's owed on my credit card. I have the % of use on that card in D1, IE 35%. I want the font color to change green when the % drops below 30, and turn red when the % goes above 30. In D1 I have the formula =(B1/C1), the cell is formatted for % 2 decimals which puts the answer in B1.

plus moins

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, it is suggested to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!