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

Hi,

I want to all the cells to change colour automatically to either green, amber, red depending on the date

Kind regards, Damian

 

[MARK858]

Re: Formula/macro help with Dates?e

Fluff, is asking what is the actual range your dates are in.

 

[Dpcombs]

Re: Formula/macro help with Dates?e

ah Right my apologies the range is B2 to J32

Regards, Damian

 

[MARK858]

Re: Formula/macro help with Dates?e

So your dates are in column B and you want the row to change color to column J or do you have individual dates in columns B to J and you want the cells colored individually?

 

[Dpcombs]

Re: Formula/macro help with Dates?e

Hi mark, thank you for responding and try to help me, my staff names are in column (A) going down and the training subjects are in columns (A1) going across so the expiry dates will be in the subject column against the relevant name

 

[MARK858]

Re: Formula/macro help with Dates?e

Can you clarify what your criteria is for "in date" (Green)

 

[Dpcombs]

Re: Formula/macro help with Dates?e

Can you clarify what your criteria is for "in date" (Green)

The criteria is the green is meaning the trading certificate is still valid and in date. The amber/orange will be to notify me that it is expiring in a months time and the red colour means the expiry date is now over due

 

[MARK858]

Re: Formula/macro help with Dates?e

The criteria is the green is meaning the trading certificate is still valid and in date

That doesn't tell me what the criteria for in date actually is.

 

[Dpcombs]

Re: Formula/macro help with Dates?e

https://paste.pics/0dd204ca398443ea10186e30c6378157

I have provided a link for an example using a screenshot if this helps, if you look at the dates it will give you an idea of what i am aiming to
achieve

kind regards, Damian

 

[MARK858]

Re: Formula/macro help with Dates?e

I can't keep asking the same question, what is your criteria for a date still being valid? a screenshot does not help, you need to state the criteria.