change font color depending on cell value

[Mickey]

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

 

[Don Guillett]

One way is to use conditional formatting. Select the
range>format>conditional formatting>1st condition >=95>format>add
condition>2nd condition >=75>format as desired.

 

[Teethless mama]

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

 

[Rooster]

Can Conditional Formatting also be used to fill a cell with a color?

 

[Mickey]

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,

 

[Mickey]

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,

 

[Mickey]

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]

Don - As opposed to font color - can you use conditional formatting to fill a
cell with color ? - Thanks

 

[Don Guillett]

Of course. Have you tried it. PATTERNS

 

[Gord Dibben]

Yes.

Help on CF explains all very well.


Gord Dibben MS Excel MVP

 

[Rooster]

David - Excellent - thanks for the help!

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.

 

[Rooster]

Gord - Thanks so much - I'll check out CF Help!

Yes.

Help on CF explains all very well.


Gord Dibben MS Excel MVP