conditional format max

E

ellebelle

if there are two cells containing the same value the MAX formula highlights
the
second value. Is there a formula to highlight the first instance of the
highest
value?
 
T

Teethless mama

Conditional Formatting

=AND(A1=MAX($A$1:$A$10),COUNTIF($A$1:A1,A1)=1)

Format any color you want
 
Top