Conditional Formatting Duplicates based on Reference Cell

[rslush91]

Hello,

I am looking to write a formula that will automatically highlight a cell (Column E) that contains a SKU but only if that SKU is associated with the same STORE Number (Column B). To identify this, I created a Concatenate of Store and SKU that I call SSKU (Column J). I thought I was able to solve this issue with a CountIF formula, however, I am getting some SKUs that are being highlighted that shouldn't be and then some SKUs are NOT getting highlighted that should be. I highlighted these issues in column K. Does anyone have any suggested formula edits or new formulas? I'm not opposed to adding a new helper column but would prefer not to.

[Estevaoba]

Try this:

Please Login or Register  to view this content.

[rslush91]

That kind of works but in this case it will only highlight the first instance (Oldest) of the duplicate but I would need to highlight the last (newest) instance or both instances.

[JeteMc]

You're original formula would work, just need to make one adjustment.
Formula reads: =COUNTIFS(H:H,H3)>1
Formula should read: =COUNTIFS(H:H,H2)>1
Let us know if you have any questions.