Change Font Color Based on Conditional Formatting

  • Thread starter Thread starter tj
  • Start date Start date
T

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!
 
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
 
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
 
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
 
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
 
Thank you Pete!

Pete_UK said:
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
Click to expand...
 
You can only change color via If Then if you use VB Code on the back end.
Can't be done via worksheet formula...
 
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
 
Back
Top