Conditional Formatting of Calendar with start and end dates

Hello,

I am trying to create a manufacturing schedule spreadsheet that will list by rows the different jobs with details of start and end dates. Using those dates I want to have the cells on a Calendar to be colored to represent the working days that the project will take. If the dates change then the colored dates change.

I have attached a sample of what I want it to look like but can only figure out how to do conditional formatting of one field. Does each cell have to have a different formula in the conditional formatting?

My goal is to be able to see in calendar format what days have jobs running on each day. I am hoping that once completed I could sort it by job# or part number to see what job(s) or part number(s) are being manufactured on particular dates.



Any help you can provide me will be appreciated.

Excellent! Thank you. I was working with the AND formula but couldn't get it to quite work. Much appreciated!

Another question..

So now I have the dates colored for the timeframe of the job. Is there a way that on each place that it highlights to also list either the job number or the part number? So looking at the calendar, it is not just colored but it shows more details of what is happening that day.

Thank you!

Try to mock that up by putting the job no or part number in each cell for a few days, and then ask yourself if that is what you really want to see.

It could be done using a formula in every cell, but as the display is just a summary of what is happening, you might want to reduce the details that you show, rather than increase them.

Hope this helps.

Pete

Makes sense :-) Thank you

I thought looking at the calendar for say the current week you can see the job numbers or parts being worked on. I will see if it is useful by first just manually entering the data.

I appreciate your help

Thank you. Unfortunately, this did not work. When I enter that formula in the conditional formatting I get nothing returned. The color goes away as well.

Thats what I was thinking. Just freeze the columns so the job and part number will always show.

Thank you