On Dec 8, 1:58*pm, Shapper wrote:
On Dec 8, 1:54*pm, Ixtreme wrote:

On 8 dec, 14:33, Ixtreme wrote:

Miguel

You should use conditional formatting to do that.

Something like:
=A1NOW() * --- Red
and
=AND(MONTH(A1) = MONTH(NOW()), YEAR(A1) = YEAR(NOW())) * * *------
Orange

Sorry for the multiple messages.
I was trying the new Google Groups and I kept getting an error when
posting.
And somehow Google stored my trials and posted all at once.

I was trying Conditional Formating and used the following:

Selected the Cells then:
Conditional Formatting Highlight Cell Rules A Date Occurring
Next Month

This works if the date in the cell is in the Same Year and next month.
But if the date of the cell is 06-01-2011 and today is 08-12-2010 then
this does not work.

Any idea?

Thank You,
Migurl