If you data is in Columns A - C put this formula in D1 and copy down the row
for testing. You can add the same formula into a conditional format if it
works. thsi is a formula array and you need to put in Shft-CNTL-ENTER to get
the {} around the formula.

=IF(AND(C1=MAX(--(A1=A$1:A$17)*--(B1=B$1:B$17)*C$1:C$17),SUMPRODUCT(--(A1=A$1:A$17)*--(B1=B$1:B$17))1),TRUE,FALSE)

"pgarcia" wrote:

Hello all,
I have set of data runing from A-C. A and B have dups and C does not, but C
has a differect dollar amount for the dup. I need to high-li the large of the
two (or 3 or 5) amounts. For the first part I have the folling:
=IF(OR(A3=A2,A3=A4),"Duplicate","") and that works. Thank
Data
ATLAKLExpress AKL 5.01
ATLBHXExpress BHX 3.47
ATLBKKExpress BKK 10.20
ATLBRUExpress Duplicate BRU 3.47< -- High-li
ATLBRUExpress Duplicate BRU 1.55
ATLCPHExpress CPH 3.78
ATLDUBExpress DUB 4.20
ATLHAJExpress HAJ 1.54
ATLHKGExpress HKG 1.26
ATLHYDExpress HYD 1.55
ATLICNExpress ICN 1.52
ATLJNBExpress JNB 2.90
ATLLHRExpress LHR 1.92
ATLPLHExpress Duplicate PLH 1.92
ATLPLHExpress Duplicate PLH 3.38<-high-li
ATLPVGExpress Duplicate PVG 2.41
ATLPVGExpress Duplicate PVG 2.41< not sure here