You're right, it works! I must have typed it in incorrectly. So I copied and
pasted.

Thanks,
--
Howard


"JAdamJ" wrote:

I copied and pasted it exactly as I have it written below, and it's
highlighting the December 31, 2005 column. Are you sure you need to change
the +1 to -1?

"Howard" wrote:

Oops, it's not working. It highlights the January 31, 2006 column instead of
the December 31, 2005 column.
--
Howard


"JAdamJ" wrote:

if you are sure that your dates are the true month end dates, try this:
=AND(MONTH(A$1+1)=MONTH(TODAY()),YEAR(A$1+1)=YEAR( TODAY()))

If you don't include the Year then you will highlight the previous month for
every year on your spreadsheet.

"Howard" wrote:

In cells a1, b1, etc., I have the month-end date, like 12/31/2005. Now that
January 2006 has rolled around, I want the column with the date 12/31/2005 to
highlight using conditional formatting.
The Month function works well within the current year
(=MONTH(a$1)=MONTH(TODAY())-1, but how do I get the prior year-end month
(Dec) to highlight when the first month of the current year rolls around?
--
Howard