Conditional Formatting

Hi,

Using Excel 2003 and would like to add some formatting features.

The sheet in question list customer records including renewal dates. Because these dates vary from customer to customer I’m finding it difficult to keep track for sending out reminders of renewals. I would like to make the renewal dates on the sheet sensitive to the current date so that I get a prompt (by change of colour) about 10 days before renewal date. Is this possible I have been looking at Conditional Formatting without success.