Hi Harry

In H2 enter
=INDEX($1:$1,MATCH(MAX(A2:E2),A2:E2,0))
Copy down as required.

There is no way you can get a formula to send data to a printer or to
another sheet.
You could, on another Sheet say Sheet2, enter in A1
=Sheet1!H2
and copy down

--
Regards
Roger Govier

"Harry" wrote in message
...
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