I am trying to apply a conditional format to a range of weeks, I want
the week with the greatest build percent highlighted:


store wk1 wk2 wk3
1 -32% 50% 75%
2 -20%30% 40%

I would like store 1's week 3 highlighted and store 2's week 3
highlighted because these weeks represent the highest percent build.

Can I use a conditional format or is there another way to highlight the
greatest value?


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