View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
learningaccess learningaccess is offline
external usenet poster
 
Posts: 37
Default format number custom want some values in red

Hi.
I have a spreadsheet showing percents. Some are over 100%, some are less
than 100%. Say for example, 125% and 65%.
Can you please tell me how I can make a custom number format to make the
percentages less than 100% show up as red? So 125% would remain black but
65% would turn red, for example.

This is a bit urgent. Your help is greatly appreciated.
--
Thanks!