28

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?

1
  • 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
26
  1. Select your cells.
  2. Home Tab -> Format Group -> Conditional Formatting -> New Style: True Values
  3. Repeat step 2 with this: False Values
4
  • 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
  • 1
    @Microsoft: How about a preset for this?
    – normanius
    Oct 24 '19 at 21:05
  • doesn't this answer depend on the locale, because it relies on the text presentation of boolean values? I mean what if I have a boolean cell in an Excel-file created by my Korean colleagues? or if I use a Russian locale in my Excel? will the formatting disappear? Jul 26 at 20:50
2

For Windows version. Microsoft 365 Excel (Version 2004(Build 12730.20270) *Note the version is not the year - this is the 365 version in year 2020

You need to create 2 rules (one for each colour) Go to

  1. Home Tab -> Styles Group -> Conditional formatting -> Manage rules
    *Alternatively just type Conditional formatting in the search bar at the top

  2. New rule

  3. Rule type -> Format only cells that contain
    Cell Value -> Equal to -> {your value in this case True} =TRUE
    And select the format, then okay

enter image description here

  1. this will take you back to manage rules where you now have one rule. Now do steps 2-4 again but for the False value

enter image description here

Now you should have 2 rules in your manage rules window

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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