Thanks everyone for the post, the VBA macro to highlight the cells work perfectly.

If anyone could also help me out with the sorting and matching the dates I would highly appreciated it.
Please see the attached file in the post.

Thanks in advance.

Vku