Try =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Clyde" wrote in message
...
My formula produces a dd-mmm-yyyy result which is correct.

Cell L55 formula results a 17-May-2006

Conditional formatting is set to: Formula is: =L55<=TODAY()

With background pattern set to red.

My problem is that the conditional formatting doesn't produce the results
I
desire which is that if the date in L55 falls within the month and year
that
the background will be red.

How do I get the conditional formatting to do this?