I am wanting to highlight a row if it matches another row in the sheet

I work on security access control systems, and we have a customer who has 94 access levels (that's insane). I'm working on a spreadsheet that shows which doors are on each access level and want to do conditional formatting if 1 row matches another row exactly. I would like to have different colors for different sets of matching rows, if possible. Can anyone walk me through it? I can post the sheet if needed, but I'm still working on it. 94 access levels at 4 doors per module and 7 modules is turning out to be a lot of data entry. access_levels.xlsx

Thanks! I used to be on excelhelpforum.com but I couldn't find it today.

As far as showing example answers, I'm not sure there are any yet. There is only 1 access level allowed per user, and if the customer wants to give each person access to just certain doors, and every person has a different set of doors, it could result in many access levels, but I have a feeling there IS some overlap.

modules screen.png

Would it be any easier to add info via a form? (see above)
Just click the items and it will add to the count.

I am already pulling this data from a form of sorts. This data is being pulled from a live access control panel. The customer is wanting to reduce the amount of options when adding a user to the system.

A little more background: each one of these rows represents an "access level". An access level defines which doors a user is allowed access to at which time of day. If you notice, some rows look almost the same, but instead of a 1, it might have a 3. The difference is 24 hour access to the door instead of M-F 8AM-6PM. I used numbers to represent the time frames because it's easier/faster than typing out exactly what each number means.

Originally Posted by FDibbins

OK, I think I have something that you may be able to use.

1. create a helper column to the right of your data (I used AM) and copy this down...
=D3&E3&F3&G3&H3&I3&J3&K3&L3&M3&N3&O3&P3&Q3&R3&S3&T3&U3&V3&W3&X3&Y3&Z3&AA3&AB3&AC3&AD3&AE3&AF3&AG3&AH3&AI3&AJ3&AK3&AL3

Then for the CF, highlight your range that you want colored, select New Rule/Use Formula, and paste this in...
=COUNTIF($AM$3:$AM$26,$AM3)>1
format fill red (or your color)
adjust the bolded part as needed for your range

this is not working for me. Am I doing something wrong? access_levels_test_withCF.xlsx

Ah, its working now. Thanks

LOL, Formula and formatting work great with an example, but in the working spreadsheet, none of them are highlighted yet, meaning no duplicates. I think I will manipulate it slightly.