MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Anyway to set date-deadlines?

Posted by Loc on February 11, 2002 10:39 AM

I would like to set this function up:

I have a column of things entitled: "DUE DATE"

I would like to have it so that if the date in the DUE DATE column has passed, Excel automatically turns that date into BOLD/Bright red.



Posted by bosco on February 11, 2002 10:51 AM

use conditional formatting on your due date cells
in the condition, put date < =now()
then select the format you'd like to see

Posted by Aladin Akyurek on February 11, 2002 11:02 AM

Assuming that due dates are in E2:E100 with E2 containg the first due date:

Select the range of due dates;
Activate Format|Conditional Formatting;
Choose "Formula Is" for Condition 1;
Enter as formula:

=E2 < TODAY() [ or =E2 <= TODAY() ]

Activate Format;
Select the appropriate attributes on the Font tab;
Click, OK, OK.