Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font color based on what is entered in the cells. E.g. If the value is Active, than make the color green and if it's Requested make it orange.


share|improve this question
up vote 5 down vote accepted

What you are looking for is conditional formatting.
Here's a quick tutorial.

share|improve this answer
Nice, that link is 100% what I needed. Thank you for your time and contribution! – hsatterwhite Jul 26 '10 at 13:10

+1 for the tutorial link that @JNK supplied

I'm adding an answer here that has the actual steps, that have been taken from the tutorial. You never know when one of Microsoft's links stop working.

How to Apply Conditional Formatting

To apply conditional formatting to one or more cells,

  1. Highlight your cell or range of cells.
  2. From the Format menu, select Conditional Formatting…
  3. In the Conditional formatting dialog, select Cell Value Is in the first drop-down box.
  4. Select a cell evaluator from the second drop down box. Your dialog may change and add another field.
  5. Enter your values in the remaining text boxes.
  6. Click the Format… button.
  7. Choose your format options from the Font, Border and Patterns tabs.
  8. Click OK.
  9. Click OK or add another condition.
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .