kellyhell
03-12-2012, 01:52 AM
Looked and looked but can't find what I'm after.
I am after some code that changes the colour of any cell in column D based on dates.
The cell will change colour if the date is older than 12 months, 18 months, 2 years or 5 years. Different colour for each trigger date.
The code will trigger when the workbook opens and will check the sheet for the above triggers.
Thanks in advance
I am after some code that changes the colour of any cell in column D based on dates.
The cell will change colour if the date is older than 12 months, 18 months, 2 years or 5 years. Different colour for each trigger date.
The code will trigger when the workbook opens and will check the sheet for the above triggers.
Thanks in advance