Conditional formating, but ignore dups

[bbond]

I have a column of numbers. I need to format the max (no problem), BUT if I have two or more values that match and are equal to the max, I want to ignore formatting for the second and subseqent duplicate entries.

Thanks in advance

 

[mikerickson]

Pehaps a formula like
=AND(A1=MAX(A:A), MATCH(A1,A:A,0)=ROW(A1))

 

[bbond]

Mike, I don't understand what your formula is trying to do and how to apply it to my applications.

Let me make my description a little more clear. F3:F7 starts off with zero's in all cells. As each cell is changed to some value, I need to look at the entered value, compare it to the other 4 values and if it is the max, conditionally format it (let's turn it blue for example). As each cell is changed it can conceivably be the new max (F3 would always be max (initially) since it will be the first cell changed). Now, lets say that data is entered as follows: 5.3, 6.2, 4.8, 5.3, 6.2. Initially 5.3 would turn blue since all other cells are 0.0, but when F4 is entered, F3 drops the blue (turns back to black text) and F4 turns blue. No change occurs with F5 and F6 entries. When F7 is entered, it matches the F4 value, but I don't want it to turn blue. Is that what you understood in my original post?

If you think your formula will do what I need, please talk me through it.

Thanks

 

[mikerickson]

Select F3.
Set Conditional Formatting to the classic Formula
=AND((F3=MAX($F$3:$F$7)),(MATCH(F3,$F$3:$F$7,0)+2=ROW(F3)))

Copy that formatting and paste it to the rest of F3:F7.

 

[bbond]

Appreciate the help Mike. I created the conditional formating in D3:D7 and H3:H7 by changing the appropriate letters. Everything worked great! However, when I tried to repeat it in D11:D15 and H11:H15 it didn't work. What am I missing? I've got the sneaky suspicion that it has to do with the +2 in the match, but I have not been able to find any help in the help files as to what that part of the match function does. I hate to keep asking for help, but I'm stumped. If you could, give me a description of what the last part of the match is actually accomplishing.

Here's what I entered for the conditional formula in D11:D15
=AND((D11=MAX($D$11:$D$15)),(MATCH(D11,$D$11:$D$15,0)+2=ROW(D11)))

Also, if I just copy and paste D3:D7 to D11:D15 is there a way for the conditional formatting to follow the copy?

Thanks for your help

 

[mikerickson]

for a data range starting in row 11, the constant should be 10, not 2.

 

[bbond]

Thanks Mike, got everything like I want it now! Appreciate the help!!!!