Thread
:
change font color depending on cell value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett