ExcelBanter - conditional format max

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional format max (https://www.excelbanter.com/excel-worksheet-functions/113177-conditional-format-max.html)

ellebelle

conditional format max

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?

Teethless mama

conditional format max

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?

All times are GMT +1. The time now is 10:06 AM.