Change Font Color Based on Conditional Formatting

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!
 
S

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
 
M

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
 
P

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
 
P

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
 
T

tj

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
 
S

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...
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top