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

ghrek

Board Regular
Joined
Jul 29, 2005
Messages
193
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?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

queuesmef

New Member
Joined
Dec 19, 2016
Messages
22
Conditional formatting for duplicates. For Missing data - Put data in a filtered list, sort by blanks
 

ghrek

Board Regular
Joined
Jul 29, 2005
Messages
193
Conditional formatting OK

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

Watch MrExcel Video

Forum statistics

Threads
1,108,652
Messages
5,524,106
Members
409,561
Latest member
ay123

This Week's Hot Topics

Top