Search date from one spreadsheet to another

In sheet1, i wan to enter a date in cell A2

after i have enter a date, in sheet2 it will search the date entered and bold the cell to red.

*Sheet2 looks like a calender that have all the dates*

I need some help in doing this.. thanks

You can try to use this macro:

Please Login or Register  to view this content.

I hope it's what you need.

Regards,
Antonio