I am not sure if this is and if statement

September 20, 2010 at 13:26:02
Specs: Windows XP
I have a date lets say 5/12/2010, and I need that cell red flaged or whatever color, at the 11th month. So it doesn't have to be 4/12/2010 but I would like any day in the month of may or whatever month to change color one month before the due month.

See More: I am not sure if this is and if statement

Report •

September 20, 2010 at 14:24:44
What version of Excel do you need this to work in?

If 30 days is good enough, this should work in all versions, but there are also other methods for 2007 and beyond:

Use Conditional Formatting with the following Formula/Rule:


Report •

September 21, 2010 at 06:06:49
Thank you I will give it a try.

Report •

September 21, 2010 at 06:12:23
To DerbyDad03, in my example I messed up I meant 4/2011 so I need it to alert me 11months later. Is there a way that no matter what day in the month for example if my dates are 5/12/2010 or 5/25/2010 for it to red flag or alert me in april of the following year for all days in the next month? PS the version I have is Excell 2007

Report •

Related Solutions

Ask Question