Conditional formating for future date
Posted by giohess on August 09, 2001 5:17 PM
I have a spreadsheet listing employees names and the date they were hired. I need to send various notifications to them 10 months from the date of hire. I want to use conditional formating to turn the cell red when ten months have passed since the date of hire. Since everyone has a different hire date, how do I set the condition to calculate ten months past their hire date and turn the cell red?