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

[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.

 

[Ron Coderre]

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)

 

[Nick Hodge]

Use conditional formatting. Format>Conditional formatting... Highlight the
cells and choose 'cell value' and 'greater than', then enter .9 in the box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html