hi everyone,



I would like to give a color to a date in sheet 1 if the date exists in sheet 2
how can i doe this?
it's also possible that the date exists multiple times in sheet 2

Just use conditional formatting
Not using XL 2016 I don't know how that works between different sheets

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Excel 2016/365 has no problem using another sheet in conditional formatting. The formula might be along the lines of =ISNUMBER(MATCH(E5,Sheet2!$A$1:$A$24,0)) but if you could supply a file with sample data we could give a more definitive answer.