Change Font Color Based on Conditional Formatting

[tj]

I want to compare two coluns of sales data (column A has 2007 Sales, Column B
has 2008 Sales) with the percentage of change in column C. If the percentage
of change is positive and greater than 75% I'd like to have the result show
in Green, if it is negative I'd like the result to be in Red, all other
changes can be in black. Is that possible, and if so how? Thanks for any
assistance with this!

 

[Sean Timmons]

OK, first, Fromat your Column C in Black.

Then, in Column C, conditional formatting will be:

Value is Greater than .75 Format as green.

Add...

Value is Less than 0 Format as Red

 

[Mike H]

Hi,

Select column B then

format|Conditional format|Cell value is\Greater than
=A2*1.75
Select green font
Add
Cell value is|Less than
=A2
Pick a red font
OK

Change the 2 in the above example to the row at the top of your range.

Mike

 

[Pete_UK]

Highlight the cells in column C, with C2 as the active cell. Click on
Format | Conditional Formatting then in the pop-up you should select
Formula Is rather than Cell Value Is and enter this formula:

=C2>0.75

then click on the Format button, click Colour and choose Green. Click
OK once, then click Add, choose Formula Is again and enter:

=C2<0

Click the Format button, then Colour, then choose Red. Click OK twice
to exit the dialogue box and Excel will automatically adjust the cell
references for you.

Hope this helps.

Pete

 

[tj]

Thank you! That works fine. Can that same thing be done in an "If/Then"
formula?

 

[Pete_UK]

Highlight the cells in column C, with C2 as the active cell. Click on
Format | Conditional Formatting then in the pop-up you should select
Formula Is rather than Cell Value Is and enter this formula:

=C2>0.75

then click on the Format button, click Colour and choose Green. Click
OK once, then click Add, choose Formula Is again and enter:

=C2<0

Click the Format button, then Colour, then choose Red. Click OK twice
to exit the dialogue box and Excel will automatically adjust the cell
references for you.

Hope this helps.

Pete

 

[tj]

Thank you Pete!

Highlight the cells in column C, with C2 as the active cell. Click on
Format | Conditional Formatting then in the pop-up you should select
Formula Is rather than Cell Value Is and enter this formula:

=C2>0.75

then click on the Format button, click Colour and choose Green. Click
OK once, then click Add, choose Formula Is again and enter:

=C2<0

Click the Format button, then Colour, then choose Red. Click OK twice
to exit the dialogue box and Excel will automatically adjust the cell
references for you.

Hope this helps.

Pete

 

[Sean Timmons]

You can only change color via If Then if you use VB Code on the back end.
Can't be done via worksheet formula...

 

[Pete_UK]

You're welcome.

Sorry for the duplicate posting - Google Groups was acting up so I
used Outlook Express, only to find that the first one went through.

Pete