Is there a way in which you can make Excel mark the higest number in a row or
column?

Example:

A B C
1 1 3 2

In this example, I would like the cell B3 (or the text in the cell)
automatically highlighted, as it being the higest value of the three cells
A1:C1

Is this possible?

Thank you for any answers!
Thomas Bentsen



"Ron de Bruin" skrev:

Hi Michael

You can use this to get the value

=MAX(A1:A20)

and this to count

=COUNTIF(A1:A20,MAX(A1:A20))

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Michael via OfficeKB.com" wrote in message ...
I have a lot of spreadsheets with many rows and columns of numbers. I need
a way to find the highest value in each row, (mark it some how, bold the
number maybe), then count the number of "highest" values are in each
column.

Is there an easy way to do this?

Thank You,
Michael