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

conditional formattingmicrosoft excelmicrosoft-excel-2010

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?

Best Answer

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