jskobel
New member
- Joined
- Mar 24, 2020
- Messages
- 8
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office Professional Plus 2013
Hello,
I have searched the web for answers on how to do this, but to no avail. i would like to have a vba (or formula) to change the fill color of a cell based on when the task was completed and when the task is to be done again. For example, if i cleaned the stove on 1/15/20 i would like that task box to be filled in with a color and then based on the frequency of the task, fill in the cells of the coresponding dates when the task needs to be done. I have attached a sample of tasks that need to be done. The first task is completed with the cells filled in the way i would like to be able to do the rest of the sheet.
NOTE: on the Frequency column (B) the codes are as follows:
D = daily
Q = quarterly
Y = yearly
W = weekly
M = monthly
SA = semi-annual
2-5Y = 2 to 5 years
5Y = 5 years
Any and all help is greatly appreciated.
I have searched the web for answers on how to do this, but to no avail. i would like to have a vba (or formula) to change the fill color of a cell based on when the task was completed and when the task is to be done again. For example, if i cleaned the stove on 1/15/20 i would like that task box to be filled in with a color and then based on the frequency of the task, fill in the cells of the coresponding dates when the task needs to be done. I have attached a sample of tasks that need to be done. The first task is completed with the cells filled in the way i would like to be able to do the rest of the sheet.
NOTE: on the Frequency column (B) the codes are as follows:
D = daily
Q = quarterly
Y = yearly
W = weekly
M = monthly
SA = semi-annual
2-5Y = 2 to 5 years
5Y = 5 years
Any and all help is greatly appreciated.