Actually, even though the formula itself cannot send data to a printer,
there's an easy way to print it out...

1. Add an additional column to the sheet called MAXIMUM.
2. Set the value of each cell to the maximum value of the other entries in
that row.
3. Select that column using Set Print Area.
4. Print!

"Roger Govier" wrote:

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