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 ...
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.