Let's say your range is from A1:A14 and you start selecting the range in A1.
Go to Conditional format and enter something like this for the formula.


=$A1=LARGE($A$1:$A$14,10)

Set the format as desired.

HTH,
Barb Reinhardt

"Help Wanted" wrote:

i would like to know how to highlight the ten highest numbers in a range
without doing it manually.