Forum Discussion
Solved
Identifying duplicates including a range of two cells in a row
I have a spreadsheet with conditional formatting (CF) intended to call out duplicates in column C entries.
At present, the worksheet colors the cells red if a duplicate is detected.
I’d like to modify the CF to call out duplicates in column C only if column B entry is also a duplicate.
The end result, in the attached example, would only show cell C4 as a duplicate.
Can this be done?
4 Replies
I'll be interested if somebody else comes up with a better (more elegant) solution. In the attached, I simply concatenated the two values (from Columns B and C) and used the same rule you've already been using.
As you'll note, if C4 is qualified, so is C3--either they both meet the criteria or neither does.
