Hi mehmetcik,

Thanks for the quick reply!

Editing the range that the conditional formatting applies to does work but it makes the range only look at the reference cells D4:E4 in the sheet Olive. Eg if I set the range from C6:J6 to C6:J18, it will show be duplicates found in C6:J18 when referencing to D4:E4. But I need the roster to look up row by row. ie:
C6:J6 looks at duplicates in D4:E4 in Olive sheet
C7:J7 looks at duplicates in D5:E5 in Olive sheet
C8:J8 looks at duplicates in D6:E6 in Olive sheet
Etc...

So is there a way to adjust it so the conditional formatting does that?

Thanks!