We use Outlook 2010 and we have got at shared calendar for our workgroup. We use it to add our meetings and appointments. We Always invite the account with the shared mailbox to our meetings or forward meeting requests to it so that we all are able to see where our colleagues are.

To get a better view we categorize so that each person in our workgroup have a specific colour. Then we choose categorize and manually add all persons in our workgroup that are invited to a meeting. By doing this we get a multi coloured box that show in colours who in our workgroup is attending.

Now I want to make the categorization automatic and this is done by using conditional formatting. I set up conditional formatting for each of my colleagues and then try but I only get one coloured boxes in Outlook.

is it possible to achieve the same categorization as manually but to have it done automatically without adding VBA?

Hi,

May I know how you configured the Conditional Formatting in detail? Especially what conditions you selected.

As for the question, there is no build-in feature in Outlook to realize your request, the only method I can think of is to use VBA.

Regards,

Melon Chen
TechNet Community Support

Hi Melon,

Thank you for answering fast.

What I did was I created a condition formatting per each person in our workgroup and gave them a separate colour. The condition I set was when that person was attendee to an appointment.

It gave me a colour code when showing up in my calendar but when more than one person was attending there was no additional colour codes. It just show the colour of the rule that was highest in my rule list.

I hope this is what you ment with your question.

Regards,

Peter Mattsson