Formula to add dates for conditional formatting in Excel 2010
Posted on 2013-11-05
I am creating a spreadsheet to track expiration dates. I have several columns of dates. I need to highlight the cell red if the date is 2 or more years ago or if the cell is blank; highlight it yellow if the date will be 2 years old within the next 30 days, and highlight the cell green if the date is less than 2 years minus one month old.
I can set up the conditional formatting but my formulas aren't working right. I've been trying it with the IF function but I have a hard time manipulating dates.
Can anyone help me with the formulas?