You can have up to 3 conditional formats in a cell without using VBA
Look for the Add button on the Conditional Formatting button
You could try, for example
cond 1: =AND(MONTH(L55)=MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
cond 2: =AND(MONTH(L55)<MONTH(TODAY()), YEAR(L55)=YEAR(TODAY()))
cond 3: =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
...
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?