I have a spreadheet that contains several different certifications per employee, based on the type of certification depends on when it will expire. For example, the CPR certification will expire two years from the date listed in the cell. I need to write a conditional formatting rule that will highlight the cell yellow when the date is a month away from expiration, and red when it is in the month of expiration. I need the rule to highlight based on soley the month ad not by the actual date in the month. If the date is 4/24/12, i need to highlight the cell yellow when todays date contains any day in March 2014 and red when todays date comtains any day in April 2014.

Currently i have the following rules written but I noticed they highlight only when the expiration date hits for the exact day in the month and not the month as a whole.

=EDATE(TODAY(),-23)>=I10
=EDATE(TODAY(),-24>=I10

Thank you