Forum Discussion

Danger_SF's avatar
Danger_SF
Brass Contributor
Jan 05, 2023
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 ...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 05, 2023

Danger_SF 

 

Cond. Format. rule that applies to $C$3:$C$12:

=COUNTIFS($B$3:$B$12,$B3, $C$3:$C$12,$C3) > 1

 

Same Note as mathetes 

  • Danger_SF's avatar
    Danger_SF
    Brass Contributor
    Jan 05, 2023
    Thank you both. I appreciate the help.
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jan 05, 2023
      Glad we could help Danger_SF & Thanks for providing feedback

Resources