Formula/macro help with Dates?

[Dpcombs]

Good afternoon guys/girls!

I am am new to this board and pretty much to excel so I reach out to all you experts for some very much needed help as I need this for my job role.

I am recording training for staff at work and require a traffic light system for training dates, I require the following cells to change colour

. When training is in date the cell automatically goes green.
. When training is coming up to the last month before expiry the cell goes orange/amber.
. When the training date expires the cell automatically goes red.

could somebody please help or guide me how to do this please?

 

[Dpcombs]

Re: Formula/macro help with Dates?e

Thanks for your time and help Mark very much appreciated but there is no need to have that attitude, the whole idea of a forum is for people to come together and gain knowledge and advice from people who have more than others and to be kind enough to share there knowledge.
I am a complete novice when it comes to excel and have recently took on a new job role that involves using excel a lot more than i have ever done, so i do not know what you been by criteria regarding a spreadsheet. sorry if i do not come across as knowledgable as you but this is why i am visiting this site and tapping in to people like yourself but do not expect arsey comments like this.

Kind regards, Damian

 

[MARK858]

Re: Formula/macro help with Dates?e

But you are not answering the question, you must have some criteria why a date is valid, I can't help you unless you tell me what the criteria is.

 

[Fluff]

Re: Formula/macro help with Dates?e

Select cells B2:J32
On the Home tab select Conditional Formatting
Select New Rule
Select Use a formula
Enter this formula =B2< TODAY()
Click Format & select Fill & then red
Click Ok & Ok again.
That will highlight all cells that are older than today in red.