Highlight all cells in a worksheet containing a specific date

Hello,

My latest challenge has proven way beyond my feeble vba skill set and I'm hoping someone can help.

We have a large worksheet with many columns containing dates in format dd/mm/yyyy hh:mm (the columns are not adjacent). We have to be able to quickly find cells with specific dates for review and audit purposes. Presently this can only be done using an auto-filter search on each and every column containing dates and is very time consuming.

We need a macro to search all rows and columns and identify those cells that contain a specific date by changing the cells interiors to red and cells borders to thick blue. (or something equally distinctive)

Achieving the above would be considered a major success and I could happily stop there, however I would like to go a step further if possible - I would like the means to remove those highlights when review is complete!.

I hope someone has done something like this before and has time to assist.

Thanks very much

Apologies, I should have said I am working with Excel 2003 SR3.

Thanks etaf,

That works for me.

Regards,

Phil

glad to have helped