conditional formatting a due date with a traffic light system

Hey there people I have an issue that I have a problem with and I was wondering if anyone here could help.

My wife has been handed the task of putting together a training matrix for all of the nurses on their team, the idea behind this matrix is that it would show each individual set of skills that a nurse possesses and to highlight specifically when those skills will need updating. My idea would be to insert a date that the training took place and that the cell would highlight Green while the training is current, I would also like the Cell to highlight Amber when the training is coming close to its due date and highlight Red when it has expired. I have tried several formula that I have found on the web such as =NOW()+30 and =TODAY()+30 etc and setting colours for the various gaps that I would like...

I have three questions -

Firstly am I using the correct formula's for what I wish to do, and if not can anyone suggest an alternative?
Can the traffic light system work, as in can I set three different colours for for each cell that will change as a set date approaches?

Any further advice on this would be splendid. Thanks.

Thank you for the reply. That formula does not seem to work unfortunately. The only that I can get to work is if I set a formula for today's date and actually set the formula to highlight today. Very strange this

Thank you. I have attached a copy of the book to this reply. I would like the Cells between B2 and M24 to show the colours of traffic lights dependent on the date that is entered. I have attempted to use the following formula...

=AND(ISNUMBER($B2),$B2-TODAY()<1) to show the colour RED for any expired dates
=AND(ISNUMBER($B2),$B2-TODAY()>7) to show the colour AMBER for any dates that are approaching expiry
=AND(ISNUMBER($B2),$B2-TODAY()>30) to show the colour Green for any dates that are some way off expiry. I have tried numerous times to get this to work and all I seem to be able to achieve is all dates assume a single colour rather than the date they are supposed to based on the formula. If you can be of any assistance I would very much appreciate it.

Examine this file. Not clear about the need for ISNUMBER function. Dates are numbers.

Unless there is a chance that text will be in those cells there should be not need for it.

If there is a chance that the dates might be entered as text I've applied a double

unary "--" to the $B2's in the formulas. This device coerces dates entered as text

into their underlying numeric values. If other than text representations of numbers

are entered they will evaluate as 0 and format red. If that needs to be addressed let us know.

I replaced the 7s with 8s and 1s with 2s. When I entered 1/1/2015 formerly (TODAY() is 1/8/2015)

B2 remained green. Now it becomes yellow. Ditto on the 2s. If I interpreted correctly I

believe this produces the desired results.

Many thanks. I Will check it on my laptop when I get home but what I wanted was for dates with more than 30 days to go to be green, less than 30 days to go to go amber and expired dates to go red.