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.

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
    
Have you considered following up with your previous questions? Your accept rate looks low... –  Tom Wijsman Aug 23 '11 at 17:43
2  
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

1 Answer 1

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

 
discard

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.