Conditional formatting not working for next month (2016)

Hi

I have conditional formatting set up for a column (see screenshot) everything was working fine until the date inserted for "next month" became say 2/1/2016 now the last format does not work. Am I missing something simple here as it did work up to any date in Dec 2015 ?

Any help or pointers appreciated.

Davy

It should be more easier if you use formulas in the cf rules.

In this case we need a small example sheet to work on it.

I've just done something similar at work this morning.
I want to highlight contracts that expire within the next 2 months.

I used this formula

=(AND($A4<>0,EDATE($A$1,2)>=$A4))

where A1 is today's date and A4 is the date the contract expires.
So the formula is effectively saying
If the there is a date in A4 and today's date plus 2 months is greater than the contract date then the contract will expire in the next two months.
Be aware the highlight will still show when the date has expired.

Maybe you can base something on this?

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Probably i miss something but this looks that works ok.