I got this to work except for if a column contains nothing, then it doesn't count that as a match. I pasted rows that match up on the 5 columns I indicated in my COUNTIFS formula, but I have to remove one of those columns as it typically doesn't have any data entered into it (it's header is "special features," and most entries don't have that.)
If I compare the 4 columns with entries instead of the 5 columns (incl. the one with absence of data), it works.
Here's my formula:
=COUNTIFS($B:$B,$B1,$C:$C,$C1,$D:$D,$D1,$F:$F,$F1,$G:$G,$G1)>1
I want to include column "E", but then the conditional formatting rule fails to identify duplicates.
Why doesn't the conditional formatting rule understand that the absence of an entry is still a value (value of "null"?), and compare?
My answers
I got this to work except for if a column contains nothing, then it doesn't count that as a match. I pasted rows that match up on the 5 columns I indicated in my COUNTIFS formula, but I have to remove one of those columns as it typically doesn't have any data entered into it (it's header is "special features," and most entries don't have that.)
If I compare the 4 columns with entries instead of the 5 columns (incl. the one with absence of data), it works.
Here's my formula:
=COUNTIFS($B:$B,$B1,$C:$C,$C1,$D:$D,$D1,$F:$F,$F1,$G:$G,$G1)>1
I want to include column "E", but then the conditional formatting rule fails to identify duplicates.
Why doesn't the conditional formatting rule understand that the absence of an entry is still a value (value of "null"?), and compare?