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?
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?