Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

I have a range containing formulas that evaluate to TRUE or FALSE.

How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?

share|improve this question
Ya I just went through all my old questions to see if I could do that, and all of them are basically still outstanding or indeterminate. – tbone Aug 23 '11 at 17:46
up vote 9 down vote accepted
  1. Select your cells.
  2. Home Tab -> Format Group -> Conditional Formatting -> New Style: True Values
  3. Repeat step 2 with this: False Values
share|improve this answer
This is for Mac, but the windows version is extremely similar, just slight modification. – tbone Aug 23 '11 at 18:46
I didn't have a Windows ready :S. – digitxp Aug 23 '11 at 18:48

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.