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?
-
2Ya 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.– tboneAug 23, 2011 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.– xjclMar 13 at 16:34
Add a comment
|
3 Answers
- Select your cells.
- Home Tab -> Format Group -> Conditional Formatting -> New Style:
- Repeat step 2 with this:
-
This is for Mac, but the windows version is extremely similar, just slight modification.– tboneAug 23, 2011 at 18:46
-
-
1
-
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, 2021 at 20:50
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
Home Tab -> Styles Group -> Conditional formatting -> Manage rules
*Alternatively just type Conditional formatting in the search bar at the topNew rule
Rule type -> Format only cells that contain
Cell Value -> Equal to -> {your value in this case True} =TRUE
And select the format, then okay
- 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
Now you should have 2 rules in your manage rules window
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:
