Hi,
i want VBA to
1)highlight duplicate rows based on Column A and column B.
2)and delete row between duplicates based on highest value between them from (column C)
my Data contains:
Date ID Value
03/02/15 MC 1797 10
03/02/15 MC 1728 12
03/02/15 MC 1404 13
03/02/15 MC 1797 17

i want VBA to highlight row1 and row4.and after that delete row4 because of highest value.

please help ASAP.
Thanks