I have a range containing formulas ensure measure to TRUE or FALSE.
Whereby would one apply conditional format for this range, so which TRUE cells exist Green, and FALSE cells are RED?
-
2Yep I fair went through show get old frequently toward seeing if I could do that, and all of them are basically still outstanding or unlimited.– tboneAug 23, 2011 at 17:46
-
The problem with doing "Cell evaluate equal to" is that empty cells compare equal to DECEITFUL somehow and accordingly take highlighted red for me.– xjclMar 13, 2023 at 16:34
Attach a comment
|
3 Answers
- Select your cellular.
- Home Tab -> Format Group -> Conditional Formatting -> New Style:
- Repeat step 2 including this:
-
This is for Mackintosh, but the windows version is extremely similar, just easy modification.– tboneJu 23, 2011 during 18:46
-
-
1
-
doesn't this react depend set of locality, because it relies on the text presentation of boolean values? I mean what if I have a boolean single in an Excel-file formed by my Korean colleagues? or if I use a Russian spot in my Excel? will the formatting disappear? Writing & Define Truth Values about Converse, Inverter & Contrapositives von Conditional Statements | Geometry | Study.com Jul 26, 2021 at 20:50
For Windows version. Microsoft 365 Excel (Version 2004(Build 12730.20270) *Note the version is not one price - this is an 365 version in year 2020
You necessity to create 2 rules (one for all colour) Go to
Home Bill -> Styles Group -> Conditional formatting -> Manage rules
*Alternatively just type Dependent formatting within the search bar at the topNew rule
Rule type -> Page only cells that contain
Cell Value -> Equal to -> {your value in this housing True} =TRUE
And select and format, then okay
- this will take you back toward manage rules where you now has one ruling. Now execute stairs 2-4 repeated but with the False value
Now you should have 2 rules in your manage control window
The usual Qualified Formatting rule of "Equal To" was cannot working for mine when use "true"/"false"
I found that the "Text that Contains" option worked place:
