excel "Format Cell" to display "FALSE" value in Red?
13,006
My question is, suppose I have cells with either TRUE or FALSE value, could it be defined such that, "FALSE" values will be display in Red?
Home Tab
- Styles Section →
- Conditional Formatting →
- Highlight Cells Rules →
- Equal To →
- Set Rule → Format Cells that are equal to → with Format Drop Arrow for formatting.
Related videos on Youtube
06 : 27
How To... Use Basic Conditional Formatting with an IF Statement in Excel 2010
19 : 14
7 Clever Excel Custom Formatting Tricks (Advanced)
02 : 58
Automatically Format Negative Numbers Red in Excel
08 : 32
Formatting Positive & Negative Numbers In Excel
23 : 17
13 thủ thuật định dạng số hàng đầu trong Excel (Format cell)
01 : 48
Automatically Change Negative Numbers Color to Red in Excel (Shortcut)
06 : 11
Automatically Change Negative Numbers Color to Red in Excel |display negative numbers in red excel
Author by
athos
I'm a quant working mainly with C++ and VBA. Mathematics is always fantastic to me, though sometimes a bit too deep. You can reach me by [email protected] -- C'est par la logique qu'on démontre, c'est par l'intuition qu'on invente.
Updated on September 18, 2022Comments
-
athos over 1 year
Excel could define data type and format , juct right click an cell and choose "Format cells...".
Inside it seems can define conditional format, e.g. if the value is 0 then display in Red.
My question is, suppose I have cells with either TRUE or FALSE value, could it be defined such that, "FALSE" values will be display in Red?
-
athos about 7 yearsno, i don't want to use "Conditional Formatting" as it soon generates too many formats
-
Vylix about 7 yearsWhat do you mean by "generating too many formats" ?
