View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Hilberg David Hilberg is offline
external usenet poster
 
Posts: 84
Default how can i choose the highest number in excel range

Select the names.
Format with Conditional Formatting.
Formula is =A2=MAX(A$2:F$2)
(Assuming scores in A2:F2)
Format as Bold (or whatever you please).

The name(s) of the top scorer(s) will appear in bold.

- David
xl2003

Robert-Alpha wrote:
i want to automatically indicate the person with the higest score ...

Name Name Name Name Name
851.18 545.74 443.38 2,663.11 3,961.84