microsoft excel course - Expiry dates on a spreadsheet

The UK's most regular instructor-led training courses.
Training information: microsoft excel course · Excel course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Expiry dates on a spreadsheet

Yvonne has attended:
Excel Introduction course

by - delegate Yvonne [1 post] (2007 Feb 28 Wed, 10:07) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Expiry dates on a spreadsheet

by - Vicki [guest] (2007 Mar 1 Thu, 15:30) Reply

You can use conditional formatting - using the IF function.

Conditional formatting in excel

by - trainer Rich platinum contributer [744 posts] (2007 Mar 13 Tue, 16:49) Reply

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

· How Excel Training Can Improve Your Company's Sales Process
· From the Classroom to the Corporate World
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips