Use conditional formatting. FormatConditional 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
DTHIS
web: www.nickhodge.co.uk
UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @
http://www.exceluserconference.com/UKEUC.html
"ullas9256" wrote in message
...
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.