If statements resulting in formatting of cells

[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?

 

[Mike H]

Hi,

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

Mike

 

[Gord Dibben]

Check out Format>Conditional Formatting


Gord Dibben MS Excel MVP

 

[ShaneDevenshire]

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.