How do you change font color based on the value input? 1 = <red>.

G

Guest

I am trying to set a column with the following funtionality:

1 = <red>1
2 = <yellow>2
3 = <blue>3
or
High = <red> High
Med = <yellow> Med
Low = <Blue> LOW
 
E

Earl Kiosterud

Mojeta,

Try Format - Conditional Formatting. Use "Cell value is." Use "Equal to"
and 1, click Format, and choose your color. Then click Add, and do the next
color.
 

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

Excel 2002: How to conditional format band of colors ? 2
Changing cell colors 1
Recognize Cell Color and Sum Data accordingly 3
How can I replace a Value in a cell with a color? 2
Conditional Formating based on Date 5
Creating drop down lists with multiple options? 4
IF Statements 3
Formula that checks several criteria before returing the value??? 4

Top