I have an Excel workbook with a lot of dates that are colored coded as follows Red indicates that the date in the cell is 13 months past the date entered in the cell Orange indicates that the date in the cell is 1 year past the date in the cell Green indicates its within the year of the date entered in the cell. As the workbook is set up now i have to manually change the color of the cell. i know there is a formula using conditional formatting that can automatically change the date but I'm not sure what that formula is. I will need this for most of the workbook. Can anyone help?
This question generated 48 answers. To proceed to the answers, click here.
This thread is current as of July 05, 2013.