36

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?

Lance Roberts
  • 8,563
  • 9
  • 49
  • 79
tbone
  • 762
  • 1
  • 8
  • 16
  • 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
  • The problem with doing "Cell value equal to" is that empty cells compare equal to FALSE somehow and thus get highlighted red for me. – xjcl Mar 13 '23 at 16:34

3 Answers3

32
  1. Select your cells.
  2. Home Tab -> Format Group -> Conditional Formatting -> New Style: True Values
  3. Repeat step 2 with this: False Values
digitxp
  • 14,432
  • 9
  • 56
  • 76
  • 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? – maxkoryukov Jul 26 '21 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

Roochiedoor
  • 129
  • 2
1

The usual Conditional Formatting rule of "Equal To" was not working for me when using "true"/"false"

I found that the "Text that Contains" option worked instead:

enter image description here

enter image description here

KERR
  • 557
  • 6
  • 8