Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 4 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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.