I recently posted a thread on changing cell colours based on the date contained in the cell i.e cell changing colour to red when over a year out of date and yellow when within a month of going out of date. The following formula worked perfectly and i would now like to have the date change green when it is between today and upto 11 months old. Is it easy to include another formula? I use Excel 2007
Formula so far:
Rule 1: format red: Formula =$A2<=EDATE(TODAY(),-12)
Rule 2: format yellow: Formula =$A2<=EDATE(TODAY(),-11)
Bookmarks