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