| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change font color depending on cell value
I need to change the font color depending on a set value between multiple
sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
One way is to use conditional formatting. Select the rangeformatconditional formatting1st condition =95formatadd condition2nd condition =75format as desired. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mickey" wrote in message ... I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Conditional Formatting:
Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Can Conditional Formatting also be used to fill a cell with a color?
"Teethless mama" wrote: Conditional Formatting: Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
I would like to be able to change them all at one time time. If there is a
formula would be great. Each sheets holds approximately 50 + columns. Thanks, "Don Guillett" wrote: One way is to use conditional formatting. Select the rangeformatconditional formatting1st condition =95formatadd condition2nd condition =75format as desired. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mickey" wrote in message ... I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
I would like to be able to change them all at one time time. If there is a
formula would be great. Each sheets holds approximately 50 + columns. Thanks, "Teethless mama" wrote: Conditional Formatting: Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
I would like to be able to change them all at one time time. If there is a
formula would be great. Each sheets holds approximately 50 + columns. Thanks, "Rooster" wrote: Can Conditional Formatting also be used to fill a cell with a color? "Teethless mama" wrote: Conditional Formatting: Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Don - As opposed to font color - can you use conditional formatting to fill a
cell with color ? - Thanks "Don Guillett" wrote: One way is to use conditional formatting. Select the rangeformatconditional formatting1st condition =95formatadd condition2nd condition =75format as desired. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mickey" wrote in message ... I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Yes.
Help on CF explains all very well. Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 10:22:01 -0700, Rooster wrote: Can Conditional Formatting also be used to fill a cell with a color? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Select your entire range & apply the CF conditions, or if you already have
the CF on one cell you can either Copy and Edit/ Paste Special, or use Format Painter. -- David Biddulph "Mickey" wrote in message ... I would like to be able to change them all at one time time. If there is a formula would be great. Each sheets holds approximately 50 + columns. Thanks, "Teethless mama" wrote: Conditional Formatting: Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
David - Excellent - thanks for the help!
"David Biddulph" wrote: Select your entire range & apply the CF conditions, or if you already have the CF on one cell you can either Copy and Edit/ Paste Special, or use Format Painter. -- David Biddulph "Mickey" wrote in message ... I would like to be able to change them all at one time time. If there is a formula would be great. Each sheets holds approximately 50 + columns. Thanks, "Teethless mama" wrote: Conditional Formatting: Condition1 Cell Value Is select between 75 and 94 format as yellow Condtion2 Cell Value Is select greater than or equal to 95 format as red "Mickey" wrote: I need to change the font color depending on a set value between multiple sheets. The sheets are for individual products but setups but have the layouts. ex: any cell with the value between 75 to 94 = font is yellow any cell with the value 95 or higher = font is red Keep in mind i need to search between 10 sheets. Thanks |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change font color depending on cell value
Gord - Thanks so much - I'll check out CF Help!
"Gord Dibben" wrote: Yes. Help on CF explains all very well. Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 10:22:01 -0700, Rooster wrote: Can Conditional Formatting also be used to fill a cell with a color? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reg. Change of font color in a cell | Excel Worksheet Functions | |||
| Change font color in cell | Excel Discussion (Misc queries) | |||
| how do i change row font color based on cell value in that row | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
Linear Mode
