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.
Thanks!
Best Answer
What you are looking for is conditional formatting.
Here's a quick tutorial.