Conditional Formatting for 6 month intervals (ignoring day and year)??

E

eleash

Joined
May 10, 2012
Messages
1
Reaction score
0
Hi,

I need to schedule case reviews on 0-3 year old children, both 6 month reviews and annual reviews. These reviews are based on the month of the child's birth. So if a child was born in January I would need a 6 month review in July and and annual in January.

I currently have my client list sorted by month, which I've added in a column using the =Text(A1,"mmm") formula. Is there a quick and easy way to have conditional formatting highlight the clients that are due for a 6 month review in one color, and Annual's in another color? Should I use EDATE and put in variables for 6,12,18,24,30 months?

thanks for any help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting dates 3
Possible Conditional Formatting 1
IF and DATE Formula Help PLEASE 6
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
Date formula where month and day remain the same, but year will va 10
Conditional Format for a date 1 month before Expiration in Excel 2 2
conditional formatting 1
Conditional Formatting Rules Manager Excel 2007 3

Top