Excel 2003 conditional formatting on future deadlines

[Racha3146]

Hi all,

First of all, I apologise if this question has been answered before; if it has I haven't been able to find it.

My query is this - I have a group of deadlines for courses done by employees and I need to highlight a) when they are overdue, b) when they have 2 months to go before the deadline and c) when they have renewed the course. Overdue will be red, 2 months will be orange and renewal will be green.

There are different courses with different deadlines. Most of the courses need renewing annually so once a course has been done, I need to highlight it in green. Two of the courses are renewed every 3 years but the same formatting will apply (i.e. colours).

If someone could help, I would be very grateful as I have searched all over for an answer. I am not an Excel wizard but I know my way around.

Cheers

Racha3146

 

[Joe4]

Welcome to the Board!

I would recommend reading up on Conditional Formatting (in Excel's built-in help files, but there are also tutorials on-line, such as this one: How to Apply Conditional Formatting in Excel: 16 steps), and giving it a shot and see how you do. You will probably need the "Formula Is" option.

If you run into trouble, then post back with the following:
- let us know which version of Excel you are using
- post a small example of your data
- let us know what you have tried