Try selecting C1:Cxx and hit ctrl while you select E1:Exxx (so that you have
both columns in the range selected).

Then with E1 the activecell
format|conditional formatting
Formula is:
=E1=MAX($C1,$E1)

Excel will adjust the column and row references for each cell in that selection.

Give it a nice shade.

JR573PUTT wrote:

I want to highlight the highest value in a row accross multiple columns,
every other column contains the value I want to reference to obtain the
MAX value:

A B C D E
S1 20 50% 30 70%
S2 30 60% 40 30%

I want to highlight the 70% because it is higher than the 20% and for
store 2 I want to highlight the 60% because it is higher than 30%. I
want to disregard the values in column B and D.

--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=515862

--

Dave Peterson