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

Change the font color based on the value of the cell 9
Remove Hyperlinks Without Changing background shading 14
Changing font color based on type cell it is. How to do it? 6
Tabname function 1
changing the color of a cell acording to its value 4
Locate and change font color 1
Need help with Lotus Notes Automation!!! 0
Color rows based on a cell value 2

Top