MFish
Board Regular
- Joined
- May 9, 2019
- Messages
- 76
Hi there,
I have a basic calendar template that I have that you can change the year and the separate tabs, which represent the months, switch accordingly to the respective year. Now, I'm curious if it is possible to have the Master Calendar, one that shows the full year, able to "read" the amount of activity the other tabs (Months) have when I type in anything. What I'm using this calendar for is to coordinate the days I need to service my accounts and it'll be nice to show how much work, based off of a color scheme, to show how much I have to do for that day. For instance, if I have 5 entries added, it'll be Green, 10 will be Yellow, and 15 will be Red, etc. How can the master sheet at the front show this? Is it with conditional formatting? Thank you.
I have a basic calendar template that I have that you can change the year and the separate tabs, which represent the months, switch accordingly to the respective year. Now, I'm curious if it is possible to have the Master Calendar, one that shows the full year, able to "read" the amount of activity the other tabs (Months) have when I type in anything. What I'm using this calendar for is to coordinate the days I need to service my accounts and it'll be nice to show how much work, based off of a color scheme, to show how much I have to do for that day. For instance, if I have 5 entries added, it'll be Green, 10 will be Yellow, and 15 will be Red, etc. How can the master sheet at the front show this? Is it with conditional formatting? Thank you.