1

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?

2

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.

enter image description here

enter image description here

0

Sure, why not? Since you already know Conditional Formatting

  1. Pick "Use a formula to determine which cells to format"
  2. Put =FALSE as the formula
  3. Click Format, then format it as red as you see fit (maybe red fill or red text, but you need to select a suitable fill to improve readibility)

Just use the same method to format TRUE, if you want it blue or green or whatever. You will get two rules, one for red false, and one for true.

  • no, i don't want to use "Conditional Formatting" as it soon generates too many formats – athos Apr 21 '17 at 2:25
  • What do you mean by "generating too many formats" ? – Vylix Apr 21 '17 at 2:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.