Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Expiry dates on a spreadsheet

microsoft excel course - Expiry dates on a spreadsheet

ResolvedVersion Standard

Wed 28 Feb 2007, 10:07 Delegate Yvonne said...

Yvonne has attended:
Excel Introduction course
Excel Intermediate course

Expiry dates on a spreadsheet

I have a list of contracts which need to be renewed and would like to know how to make the expiry dates show up in red three weeks before they are due to expire.

Thu 1 Mar 2007, 15:30 Vicki (guest) said...

RE: Expiry dates on a spreadsheet

You can use conditional formatting - using the IF function.

Tue 13 Mar 2007, 16:49 Trainer Rich said...

Conditional formatting in excel

Yvonne,

As suggested by Vicki, you can use conditional formatting. Select the cell (or column/row) you wish to colour, go to Format -> Conditional Formatting... and create a rule and style that matches your criteria.

Regards, Rich

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips