Conditional Formatting of a Percent Number

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

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
 
The trick is to remember that 1 is the same as 100%. If you ask for
anything <1 to be red, anything <100% will be red.
 
Remember, percentages are actually hundreths (decimals). Change your
conditions to "Greater than or equal to 0.01" and "Less than 0.01"

Currently, your condition is actually saying anything less than 100% is red.
 
Back
Top