Highlight duplicates - combo of 2 columns

[reesie]

Hi

I have 2 columns one contains a po number and the other contains a product number. I need to highlight where there are 2 occurrences of the po and product number so that I can show if the product has been ordered twice on the one purchase order number.

Please could you help.

 

[Rhodestransit]

I just did a similar thing
Assuming you are starting with c3 and end at c80 in the first column and d80 in the second column
First cell in your first column using conditional format
=COUNTIF(C$3:D$80,C3)>1
Next cell down
=COUNTIF(C$3:D$80,C4)>1
Not that the last part of the formula will change as you go down the cells

Column D cell D3
=COUNTIF(D$3:D$80,D3)>1
cell D4 =COUNTIF(D$3:D$80,D4)>1
and so on

 

[reesie]

HI thank you - just tried that and then selected conditional formatting to show highlight if duplicate and it highlighted all in range so Im really confused - thanks again new to conditional formatting

 

[Rhodestransit]

Can you give more information about what steps you did to highlight?

 

[reesie]

HI

I selected the 2 columns and then used conditional formatting and if duplicates show in red. But it changed all to red.

Thanks

 

[Rhodestransit]

I normally complete the first cell conditional format then copy and paste down through the rest of the cells