Conditional formatting of TRUE / FALSE values in an Excel 2010 range

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?


Solution 1:

  1. Select your cells.
  2. Home Tab -> Format Group -> Conditional Formatting -> New Style: True Values
  3. Repeat step 2 with this: False Values

Solution 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