I have a range of rows A3:O1980.
What I would like to do is have a vba script run on change and see if a row has a duplicate.
If So I would like for it to highlight the "matching row" range A:O
*Not sure if this part is possible
Now if possible I would like to highlight them a different color pending if it's the 2nd duplicate, 3rd duplicate and 4th duplicate.