Conditional Formatting of a Percent Number

[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

 

[David Biddulph]

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.

 

[Luke M]

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.