You can highlight the cell with the maximum value by using conditional
formatting.

Select the range to highlight (say A2:E99)
Then with A2 the activecell
format|conditional formatting
formula is:
=A2=Max($a2:$e2)
and give it a nice format.

You can return the highest value with a formula like this in F2:
=max(a2:E2)

You can return the name of the first highest value (in G2???):
=index($a$1:$E$1,match(max($a2:$e2),$a2:$e2,0))

Harry wrote:

I want to highlite the highest number in each row. Some cells could be empty
at times.
Is it also posible to take that highest number and send to print or send to
another sheet with the name of the colum. (joe etc.)
joe bill tom sue mary
a 50 34 102 20 2
b 10 35 99 5 3
c 2 56 10 1
d 13 5 55

--

Dave Peterson