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

Conditional Formatting of a Percent Number
 

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.
--
David Biddulph

"DOUG" wrote in message
...
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

Conditional Formatting of a Percent Number
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DOUG" wrote:

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