• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Format and display resource value

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
 

Attachments

  • Conditional Format with Values.xlsx
    42.9 KB · Views: 3
Back
Top