If statements resulting in formatting of cells

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Is there a way to create a IF statement that results in the cell format
changing? For example, if the resulting value is True than the cell turns
blue, if False then the cell turns red?
 
Hi,

Yes there is but without more detail providing a formula is difficult but
the answer lies in conditional formatting.

Mike
 
Hi,

1. Select the cell or range of cells
2. Choose Format, Conditional Formatting
3. From the second drop down pick equal to
4. In the next box type TRUE
5. Click the Format button to the right
6. Select the Patterns tab and a blue color, then click OK twice.
 
Back
Top