Change Font Color Based on Conditional Formatting
Thank you Pete!
"Pete_UK" wrote:
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:
=C20.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
On Oct 10, 6:45 pm, tj wrote:
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!
|