View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Leanne Leanne is offline
external usenet poster
 
Posts: 87
Default automatic font color

I have a spreadsheet where I keep track of scores that are in the form of
percentages. If the score is below 98% I want the font to be red. Is there
a way to format the column to automatically show scores below 98% in red font
and above 98% in black font? Thanks.