How to Make a Date Change Color After Expiraton in Excel

1. Open Excel 2007 and select a workbook. Click the 'Office' button and select 'Open.' Browse your files and locate the workbook. Double click the workbook name. The workbook opens.
2. Highlight a range of cells that contains dates. Select the 'Home' tab and click 'Conditional Formatting.' Select 'New Rule.' Select 'Format only cells that contain.' In the Edit the Rule Description field, select 'Cell Value' and 'greater than.' In the next field, enter your expiration date.
3. Click 'Format' and assign a format to cells that match this condition. To change the color of the cell, modify the 'Fill' tab. Emphasize the text in the cell by changing font using the 'Font' tab. Click 'OK.' The changes are immediately applied to your cells. Cells in the range matching the condition will reflect the fill color selected.