If statements resulting in formatting of cells
 

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?

If statements resulting in formatting of cells
 

Hi,

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

Mike

"Jen" wrote:

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?

If statements resulting in formatting of cells
 

Check out FormatConditional Formatting


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 08:07:02 -0700, Jen
wrote:

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?

If statements resulting in formatting of cells
 

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.
--
Thanks,
Shane Devenshire


"Jen" wrote:

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?