Formula to let me know if duplicates are found

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,625
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,118,807
Messages
5,574,426
Members
412,592
Latest member
moonsugar
Top