Conditional Formatting

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

Format any color you want


"ellebelle" wrote:

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?