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
|