Conditional Formation based on Month

**GDS** · 05-04-2009, 03:49 PM

I have a field where the month is written as text
I would like to highlight row whose month column has passed

My conditional formating code is:

Please Login or Register  to view this content.

The problem is that it highlight all the blank cell because it sees them as 01.
Any ideas how I could get it to highlight only those who month has passed while leaving those that are blank unformated.

Thank you for your help.

**ChemistB** · 05-04-2009, 04:40 PM

Please Login or Register  to view this content.

Does that work for you?

**GDS** · 05-04-2009, 05:05 PM

ChemistB - thank you, I had to change the coma to a ;, and then it worked.

**teylyn** · 05-04-2009, 05:15 PM

Let's clean up the formula. This should be in your condition box:

=AND(ISTEXT(F3),MONTH(1&$F3)<MONTH(TODAY()))

since your month is text, you need to check for text (ISTEXT) and not for numbers. Also, there was a typo in your formula (MMONTH)

The above formula worked in a spreadsheet on my computer

cheers

**GDS** · 05-05-2009, 10:01 AM

Teylyn - I tried yours and it works great too. I'm actually glad you posted because I had played around with a few cell and changed them to numbers by accident.