Conditional Formatting Formula

[weefisheads]

I enter many lines of data and am trying to come up with a formula to catch Duplicate entries. However, to be considered duplicate, it has to meet TWO criteria.

In column A, I have Cars - Honda, Ford, Toyota, etc
In column B, I have Type - SUV, Hybrid, Coupe, etc

There can be multiple occurances of the cars (many Hondas, many Fords), and there can be multiple occurances of Type (many SUVs, many Roadsters). What I'm trying to come up with is Conditional Formatting on Column B so that if there are multiple occurances of a Car & Type, it is hightlighted Yellow. IE, if A2 is Toyota and B2 is Hybrid, B10 will be hightlighted if A10 is Toyota and B10 is Hybrid.

Ugh. I hope that makes sense.

I'm pretty sure I can do a SUMPRODUCT to generate True / False, but I'm having difficulty coming up with the syntax and not sure if that can be incorporated into Conditional Formatting.

Thanks!

dB

 

[wsjackman]

maybe

conditional format formula in column B
=sumproduct((a$1:A1=a1)*(B$1:B1=B1))>1

 

[weefisheads]

Yes - that's IT!!

Brilliant - thanks!

dB