I can't add more shifts colors in a scheduled template

[Scott Curtis]

I downloaded a schedule template and added more shifts. I made sure to follow the existing formula; however the colors for the added shifts due not show up in the drop down boxes within the schedule.


Can someone help me understand what I have forgotten to do?

The passwords are password.

 

[NARAYANK991]

Hi Scott ,

Can you mention the cells where you are facing this problem ?

I checked in cell B438 on the Schedule 1 tab , and I find all the shifts entered on the Shifts tab are appearing in the DV dropdown.

EDIT :

The colors themselves are not a part of the dropdown in any cell ; they appear due to the Conditional Formatting rules which have been applied to the data range ; if you want the colors for the additional shifts to appear in the data range , you need to add them using the conditional formatting rules. See the existing ones , and add the new ones on the same basis.

Narayan

 

[Scott Curtis]

Thank you very much, I new I was missing a step.