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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting for time 1
Conditional Formatting by percent range 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Conditioning Formatting 3
Conditional Formatting Issue 3
Conditional formating problem. Please help. 7
Setting an Icon Set conditional format for a single cell??? 4
Conditional Formatting - Excel 2003 2

Back
Top