HOW DO I PROGRAM EXCEL TO HIGHLIGHT A PERCENTAGE THAT IS OVER 90%?

  • Thread starter Thread starter ullas9256
  • Start date Start date
U

ullas9256

Does anybody know how I can program Excel to highlight a field if I type in a
percentage that is 90% or greater. I use a excel spreadsheet and often plug
in percentages but I need to highlight all percentages that are higher than
90%. I usually go to each one and highlight it yellow. Is their a easier
way can't excel do this automatically after I type in the percentage? Please
help.

Thank you.
 
Try Conditional formatting:

Assuming the range to be impacted is A2:A100
Select that range.

From the Excel Main Menu:
<format><conditional formatting>
Condition_1:
Cell value is: Greater than or equal to: 0.9
Click the [format] button and set your highlight color.
Click [OK] to complete.

Now each value greater than or equal to 90% will be highlighted.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top