I'm making a wiring diagram/list in excel and need to find a formula for conditional formatting that will turn 2 cells red if those two cells in a given row appear anywhere else on the spreadsheet.
I already have 2 formulas for (Wire Origin and Wire Origin Terminal) and (Wire Destination and...