Formula to let me know if duplicates are found

[tonywatsonhelp]

Hi everyone,
i can use conditional formatting to let me know if i have any duplicates in column D
this work great but I'd like to be notified on a different sheet.

So if i was doing this in English I'd put: if sheet "Data" column D has triggered the conditional formatting to make any cell green then "Warning, Duplicates in Data!" if not ""

can this be done as I cant get it to work any ideas please let me know

thanks

Tony

 

[petertenthije]

I’d create a pivot table with data presented as COUNT, filtered on values >=2.