While In Cell B2, go to Format Conditional Formatting and
select Formula Is and in Text box enter:

=B2=MAX($B2:$D2)
choose Pattern Color,
And OK out

With B2 as the source Paint it
and paint the other cells C2,D2,B3,C3.D3



"JR573PUTT" wrote:


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