Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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.

Thanks.

Loc

Re: Anyway to set date-deadlines?

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

Re: Anyway to set date-deadlines?

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.

=========

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.