Hello,
I have created a database with scheduling rosters.
The basic idea is to have 4 teams rotate a "call" schedule with the monday team also taking the next weekend schedule (don't ask, they want it like that). I made a rule table based on all the "rules" they have for call rotation.
When I make a report I get all the data nicely in a calendar shape. I want to make the different teams on this report clearer and came up with the idea of giving them a certain color, this way they can see easily when they are "on call". I have used the conditional formatting for this, but I can only use 3 conditions, the default doesn't work right for this purpose and is really unusable.
Is there any way to make more conditions to format more colors? Especially handy if a 5th team is ever created!
Thanks,
Richard
I have created a database with scheduling rosters.
The basic idea is to have 4 teams rotate a "call" schedule with the monday team also taking the next weekend schedule (don't ask, they want it like that). I made a rule table based on all the "rules" they have for call rotation.
When I make a report I get all the data nicely in a calendar shape. I want to make the different teams on this report clearer and came up with the idea of giving them a certain color, this way they can see easily when they are "on call". I have used the conditional formatting for this, but I can only use 3 conditions, the default doesn't work right for this purpose and is really unusable.
Is there any way to make more conditions to format more colors? Especially handy if a 5th team is ever created!
Thanks,
Richard