View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default MAX in conditional formatting

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 ???