Hello,

I need a formula to help in doing conditional formatting for date

say for Example- Date given is 25/02/2012
When this date has only one month left to cross one year, that is,if today's date is 25/01/2013, it should turn yellow and when this date crosses one year,that is, if today's date is 25/02/2013, it should turn red.

Thanks