This is probably a really simple question, but I can't get my head around it.

In one Column I have a list of dates, and above it I have a calendar
template. I want to set up conditional formatting so that if a date appears
in the list, the cell of that date on the calendar is highlighted yellow.

I've used:
=$B$51:$B$105=DATE(2005,1,7)
I put this in the cell of 7th Jan 05 (not US format) This worked great and
the cell was highlighted. But when I try it with any other date after 9th
Jan 2005 it fails!
ie.
=$B$51:$B$105=DATE(2005,2,4) - This formula to highlight on 4th Feb doesn't
work!

What am I doing wrong?

All help is greatly appreciated!!

Thanks,

Nat