View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
James[_38_] James[_38_] is offline
external usenet poster
 
Posts: 7
Default MAX in conditional formatting

JE,
Thanks, it worked great
James


"JE McGimpsey" wrote in message
...
Try

Formula is =I3=MAX($I$3:$I$28)

In article ,
"James" wrote:

I'm trying to highlight (bold) a name in column A if the number in Column
I
is the MAX.
I have 25 sales person listed in A3:A28 and several columns of numbers
that
total in column I.
I've been trying to use the conditional formatting to make the name bold
if
the sale person has the highest sales figures for the week.

I've tried in the conditional formatting window, if formula is =IF(I3 =
(MAX(I3:I28)) then A3 should be bold
Any help please ???