Guys, Thank you for all the help you have provided me over the years and all the birthday wishes too. I am deeply appreciative.
Alas, I need help again.
Some time back, one or more of you took the time to figure out how, using VB, to make excel "color" date cells to identify my status as it relates to deadlines.
Here is what I needed.
I needed to have date cells on the spreadsheeet colored:
green with a visible text color until less than 2 weeks from a deadline when they would become
yellow with a visible text color, until 3 days before a deadline when they would become
red with a visible text color, until the deadline is missed and as such they would become
black with white text, along with a second similar looking cell which noted how many days overdue, and for those tasks which were completed on time, the cells would become
Gold with visible text color.
I have different due dates for different things and this color system helped me to identify at a glance what I may have overlooked.
Does it make sense?
As mentioned above, one or more of your guys (or girls) created this for me. I used that for years until my car was stolen with both my laptop and my 8tb HD backup in it. yeah, I lost a lot.
Any help you can give in recreating this for me and a refresher explaining how to get it going, will be greatly appreciated.
Thank you again for your time.
Bookmarks