Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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 "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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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 "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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
Thank you! That works fine. Can that same thing be done in an "If/Then"
formula? "Mike H" wrote: 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 "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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
You can only change color via If Then if you use VB Code on the back end.
Can't be done via worksheet formula... "tj" wrote: Thank you! That works fine. Can that same thing be done in an "If/Then" formula? "Mike H" wrote: 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 "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! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Font Color Based on Conditional Formatting
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 On Oct 10, 7:22*pm, tj wrote: Thank you Pete! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font color based on a value | Excel Worksheet Functions | |||
how do i change row font color based on cell value in that row | Excel Worksheet Functions | |||
change font color of cell based on critera | Excel Worksheet Functions | |||
How do you change font color based on the value input? 1 = |
Excel Discussion (Misc queries) | |||
Change Font Color Based on Classification | Excel Discussion (Misc queries) |