Forum Discussion
Solved
Excel Yearly calender conditional formatting
Hey! I am trying to make a yearly calender and automatticly format certaint days of the week. This is what i have so far! I have a dropdown list which allows me to pick the year. And i've als...
Select the cells that you want to format conditionally.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Lave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
Enter ="Sat" in the box next to it.
Click Format...
Activate the Fill tab.
Select green.
Click OK, then click OK again.
Repeat the above steps, but with ="Sun" instead of ="Sat".
My bad i am rambling.
So im trying to automatticly fill the sheet with hours of the week. Every week has the same hours.
However when there is a vacation i'd want this formula to output nothing. Empty cell or maybe like a "vrij" in it or something.
I also want the input data i have to not switch days. Now when i switch from year since i made it the same as my calender it switches days meaning Tuesday would be first on the list instead of monday. Yet the hours dont change with so u'd need to manually change the hours for the weekdays. I want this automated or the days to just not move. Which data would u need to try and help me?
So im trying to automatticly fill the sheet with hours of the week. Every week has the same hours.
However when there is a vacation i'd want this formula to output nothing. Empty cell or maybe like a "vrij" in it or something.
I also want the input data i have to not switch days. Now when i switch from year since i made it the same as my calender it switches days meaning Tuesday would be first on the list instead of monday. Yet the hours dont change with so u'd need to manually change the hours for the weekdays. I want this automated or the days to just not move. Which data would u need to try and help me?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
Solved via PM.
- I haved pmed you the file of data.