Hi All,

I have a column of names in column A

in column B I have dates

I want to do a conditional format where if the name and date in row 1 happens again, it will be highlighted

Example,

A B
John Doe 31/05/2015

if this happens twice, i want to highlight it

Thanks in advance