Need help on how to highlight duplicated entries and missing data.

[ghrek]

Hi

I have a workbook that that has data in rows B-E and I-L .

What im trying to do is to highlight duplicated entries and missing data. What I need to do is for it to look down columns B-E and then look down columns I-L and if any data missing I need the row in columns B-E highlighted. What I mean by looking for data is that the entry in in columns B-E MUST be an exact match in columns I-L to avoid it being highlighted.

All entries in columns B-E will not be in the same row as columns I-L so I need it to look all the way down columns I-L when comparing with a entry in columns B-E.

When it completed I then need it to look down columns I-L and see if there are any duplicated entries and again highlight in columns I-L .

Any Ideas?

 

[queuesmef]

Conditional formatting for duplicates. For Missing data - Put data in a filtered list, sort by blanks

 

[ghrek]

Conditional formatting OK

Confused put in a filtered list and sort by blanks? What do you mean.