I'm able to set conditional formatting to show duplicates across multiple, non-contiguous columns. What I'd like to do is, if any duplicates are on the same ROW, then DO NOT conditionally format them as duplicates. I've not been able to get this to work based on info I've found on a couple websites.
- For example, below, row Job1 has May 02 twice. I don't want May 02 to show as a duplicate because they're on the same row.
- Row Job2 has May 15, but so does row Job2, so I DO want these to show as duplicates.
I'm attaching a sample doc and would be grateful for any help. My conditional formatting chops are limited to out-of-the-box stuff, and as noted, wasn't able to get what I found online to work. Thank you!
Code:
Job Date 1 Date 2 ColumnX Date 4 Date 5 ColumnY Date 8 Date 9
Job1 May 01 May 02 Apr 20 May 02 May 15 Jun 01
Job2 May 15 May 16 May 13 May 17 Jun 01 Jun 15
Job3 Jun 15 Jun 18 Jun 10 Jun 15 May 16 Jun 18