Shift Calendar

New Contributor

I have used a shift calendar template to create a calendar for myself. What I'm not able to determine is how to change the cells to different colors. Each shift has a different color and what I set the shift colors as they are not populating in the calendar cells. 

5 Replies

@cphelps73 

for colours and mutch more

Use conditional formatting to highlight information

Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends.

Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data.

You will find more Information and exambles in the upper Link.

 

Hope I could help you with these information / links.

 

NikolinoDE

We cannot do great things - only small ones, but those with great love.

@cphelps73 

Could you share template file?

I do not see a way to attach my file.

 

 

@cphelps73 

It's here

image.png

@Sergei Baklan it tells me my .xls and .xlsx files are not supported.