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

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

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

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

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

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

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

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

change font color depending on cell value
 

Of course. Have you tried it. PATTERNS

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rooster" wrote in message
...
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

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?

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

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

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?