View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Conditional Formatting of a Percent Number

Excel does not seem to like to conditionally format numbers expressed as a
percent. I used a formula "If Greater Than or Equal to One, font is black -
and If Less Than One, font is red". But, both sets are displayed as red.
What is the trick to this?

DOUG