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 - Latest answer on Apr 22, 2016 06:13PM
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.
See more 
moins plus

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.


Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!