conditional format max

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Format any color you want
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting 2
Reference the 2nd and 3rd highest in range. 2
Trying to find additional ranges outside of min, max, and average 2
Conditional formatting 2
Conditional Formatting 1
Conditional Format based upon if statement and max 11
Finding location (or start cell) of highest consecutive values 3
Conditional format a column based on value in a different column 3

Back
Top