Change the font color based on value of cell

R

Robin

How do I get excel to change the font color based on the value in the cell,
e.g. 1 3 5 change font color to red, 0 00 change font color to green
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
How does one change the font name with VBA? 0
Change the font color based on the value of the cell 9
Remove Hyperlinks Without Changing background shading 14
Student & Home? 1
Change the colour of a neighbouring cell 6
Match table shading (color) to Visio color/Transparency 1
Problem with MS Word paragraph and character styles: format getting messed up 2

Top