Thank you very much Carim, yes it worked. However, is there a way that I
could copy the same conditional format to the rest of the cells representing
every day of the month without having to format every cell individually?

"Carim" wrote:


Hi,

Use conditionnal formatting in B4
Formula Is and enter formula =MATCH(date(2006,9,1),$A4,0)
and then select Format and Pattern which you want ...

HTH
Cheers
Carim