I want to use a formula in excel to highlight a cell 30 days prio
I am using Excel 2003. I want to have Excel highlight the cell 30 days prior
to the date that I put into the cell. Example 4/30/06...I want excel to
highlight the cell yellow 30 days prior to that date. Also...I want excel to
highlight the cell red when the date has past (expired).
|