Compare Date from a Column Cells in alternate Columns Cells

[analyst]

Ah right, sorry hadn't taken in to account that you might want to do this across workbooks.

Perhaps you could record a macro for the conditional formatting and tweak it to your liking? (e.g. to work for different ranges, remove horrible ".Select" statements, etc)

Yes, what u say is right, and instead of getting result in msg box, conditional formatting thru vba code wud be nice. I'll modify the query, and also experimenting with, what i know with limited understanding.