Link to home
Start Free TrialLog in
Avatar of Ted Penner
Ted PennerFlag for United States of America

asked on

Needed Tested Method for Highlight Duplicates

Needed Tested Method for Highlight Duplicates

If cells A1+B1 are the same as A2+B2, I would like to highlight all the instances that are duplicated.

In this case, A2+B2 would be highlighted but A1+B1 would not, since they are the first occurrence.

This needs to happen in a Google Spreadsheet.

I have made a sample
https://docs.google.com/spreadsheets/d/1vnTWNv-elPciIlYsKOV7Z_fiffS1D4TMUrY5ilk6rPc/edit#gid=1733025047

Assistance is greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello,

Are there any examples of A1+B1 being the same as A2+B2? In the sheet you shared it does not appear any rows meet that criteria.