What formula would I use with conditional formatting if I want to highlight all the cells in column B based on column A cells having duplicate data, but only if column B cells do not have duplicate data input. For example:
A B
Joe Smith Matched
Joe Smith Pending
Mary Sue Pending
Mary Sue Pending
Betty H Matched
Betty H Matched
In this example I want column B to be highlighted for only Joe Smith since he has a "Matched" and "Pending" status.
Bookmarks