I want to use VBA to help highlight when the training needs refreshing every 3 years and I want the cells in one Colum to change colour. Green, Orange, Red.
Green current date until: Orange when 6 months left then Red with only a 14 days left before expiry. Then back to green when refreshed.
It might be easy but I have not found anything as yet.
Cheers in advance.
attach worksheet as requested in 'yellow banner'
this will get a faster response.
I want the dates in Colum B to change colour as posted above
As this has been sitting a couple of days, I thought that proposing formula based conditional formatting might be appropriate:
Red: =AND(B2<>"",TODAY()+14>=DATE(YEAR(B2)+3,MONTH(B2),DAY(B2)))
Orange: =AND(B2<>"",TODAY()>=DATE(YEAR(B2)+2,MONTH(B2)+6,DAY(B2)))
Green: =B2<>""
Note that once the conditional formatting is set up on one of the sheets format painter may be used to transfer to the other sheets.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you
Its look like just what I wanted
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks