Thomas Kuriakose
Active Member
Respected Sirs,
We have a project task where we need to enter the number of resources used in the duration of the task.
Range F6:G23 has the start date and end date of the tasks
Range I6:K23 have resources.
Range L6:NL23 has the days
Fridays are holidays
Kindly guide on how to do conditional format formulas for the following -
1. Fridays with Gold color
2. Format days for each tasks with green color and enter the number of resources used for the duration based on the values in I6:K23
Sirs, is there a way to get the months and weeks populated in L3:NL3 and L4:NL4.
Kindly find attached the file created manually.
Thank you very much,
with regards,
thomas
We have a project task where we need to enter the number of resources used in the duration of the task.
Range F6:G23 has the start date and end date of the tasks
Range I6:K23 have resources.
Range L6:NL23 has the days
Fridays are holidays
Kindly guide on how to do conditional format formulas for the following -
1. Fridays with Gold color
2. Format days for each tasks with green color and enter the number of resources used for the duration based on the values in I6:K23
Sirs, is there a way to get the months and weeks populated in L3:NL3 and L4:NL4.
Kindly find attached the file created manually.
Thank you very much,
with regards,
thomas