data validation non contiguous cells

[hajiali]

Hello I have non contiguous range ($U$2:$AS$1000 and $AW$2:$BF$1000) I need a data validation to alert users when the same date is entered in both range combine more than 12 time.


Thanks

 

[hajiali]

Thanks a lot Peter. I always have issues with DV

 

[Peter_SSs]

Thanks a lot Peter. I always have issues with DV

You're welcome. Hope it all works out for you.