Use this idea. formula is
=a1=max($a$1:$a$8)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John C." wrote in message
...
I am familiar with how to find a min and max value in a table and change
the
color of the cell and even the font to bold. However, I am stumped with
this
problem. Let's say that I have data in a table from A1 to C6, and from A8
to
C13. I want to compare A1 to A8, A2 to A9....C6 to C13, and highlight the
maximum one for each comparison, so that I am comparing apples to apples.

Will someone please explain how to do this? Thanks for your
consideration.

John