Match Date Columns With Code

[swade730]

I want a vba code that can match the dates in column G & J

If there is a match I want the format to be the same as cell C8
if not, then the formatting should match C10

see attached workbook.

this is by far the hardest loops for me.

Please help

[AlphaFrog]

This could be achieved using the Conditional Formatting feature

Select column G and select from the menu Conditional Formatting
Green format Formula is: =AND(ISNUMBER(G1),COUNTIF($J:$J,INT(G1)))
Pink format Formula is: =ISNUMBER(G1)
OK

Select column J and select from the menu Conditional Formatting
Green format Formula is: =AND(ISNUMBER(J1),COUNTIFS($G:$G,">="&INT(J1),"<"&INT(J1)+1))
Pink format Formula is: =ISNUMBER(J1)
OK

[swade730]

This could be achieved using the Conditional Formatting feature

Select column G and select from the menu Conditional Formatting
Green format Formula is: =AND(ISNUMBER(G1),COUNTIF($J:$J,INT(G1)))
Pink format Formula is: =ISNUMBER(G1)
OK

Select column J and select from the menu Conditional Formatting
Green format Formula is: =AND(ISNUMBER(J1),COUNTIFS($G:$G,">="&INT(J1),"<"&INT(J1)+1))
Pink format Formula is: =ISNUMBER(J1)
OK

Do you have screen shots of this?