Bonjour Bernard,

Thank you very much for your help with my Excel question. It worked
perfectly.
Another question, if you don't mind, and I hope I'm not imposing on your
time.
Let's say that the results of the cell are less than this month and year.
How could I get that to show up with whatever color I desire? Or, vice versa,
results are greater than current month and year?
Thank you again.

A la prochaine, Clyde Barney

"Bernard Liengme" wrote:

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?