View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mickey mickey is offline
external usenet poster
 
Posts: 112
Default 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