Conditional formatting question

[hatstand]

I have a spreadsheet with 7 columns and a few thousand rows with column A being the part number and column D being the description. My problem is that when a part is entered into the database. Although the part numbers can be duplicated in column A, I need the description to match any previous description entered. I know how to make duplicate entries highlight in one column, but can it be done by combining entries.

I have to say this has me stumped without resorting to adding new columns in the spreadsheet. Any ideas would be much appreciated.

 

[hsk]

I know how to make duplicate entries highlight in one column, but can it be done by combining entries.

Why don't u concatenate 2 columns [=CONCATENATE()] and hilight duplicates in this new column ....

 

[GlennUK]

What about having Data Validation to check that the Description is the right one ( you could have the right one appear in the in-cell drop-down too )?

 

[hatstand]

thanks for the replies

I didn't really want to add another column as it may confuse staff who use the spreadsheet. And I i can't use data validation as the entries are made by automatically via a form completed by staff.

I know how to highlight duplcates. i.e. =countif(a:a,a1)>1 to highlight any duplicates in coulmn A but tring to highlight entries that are based on two criteria and not matching is a real doozy.

 

[GlennUK]

There wouldn't be an extra column?!?!? Why can't you use data validation? You can add the validation after the entries are done and have auditing circle invalid data.