Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |