Match dates from 2 different columns

Can someone help with a vba code that can match the dates in column G & J

If there is a match I want the formatting colors should match cell C8
if not...
then the formatting colors should match C10

see attached workbook.

Thank You for any assistance.

Originally Posted by kalak

perhaps try this

Please Login or Register  to view this content.

NB: This was edited from initial version because the bits in red earlier had the Int bit not included. That was just to ensure that the hours and minutes etc. in Col G didn't confuse the issue.

Thank You,
By the way why the a(45000) as Boolean, b(45000) as boolean?

"By the way why the a(45000) as Boolean, b(45000) as boolean?"

Dates on my computer run from Jan 1 1900, which is 1 in general format (or, if you like, as the computer stores it) and onwards so that March 15 2023 is 45000 is general format.

I assumed your dates wouldn't be outside this range, although can just increase the 45000 if considering say the next century. Earlier than the start of last century is very doable but requires a minor additional step.

So setting say boolean a(September 1, 2014), or if you like a(41833), as True and then looking whether the dates in the other column are boolean true or boolean false indicates whether or not the date September 1, 2014 occurs in the other column.

That part of the code is very fast. Coloring each cell individually is a lot slower but can easily be made plenty faster if you've got lots of data, say a million or so rows to compare.