tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 2,677
- Office Version
-
- 365
- 2019
- 2016
- Platform
-
- 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
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