| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
