MAX in conditional formatting

[James]

Hello NG,
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 ???
Thanks James

 

[JE McGimpsey]

Try

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

 

[James]

JE,
Thanks, it worked great
James

Try

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