Find different cells in rows that have a matching value

I’m trying to create a conditional format rule along these lines:

Highlight if multiple rows have the same value in column A and have (different values in column E or different values in column F or different values in column G).

In other words, if Column A has a duplicate, test columns E:G in the relevant rows to see if there are any differences.

I hope that makes sense, I think I need to use arrays, but not sure how to write them.

Thanks in advance!

By: Joel

Leave a Reply

Your email address will not be published. Required fields are marked *