Using conditional formatting on a shared calendar with categories

Status
Not open for further replies.

Marc S

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I have an interesting problem that I am really hoping someone has a good solution for.

Context and issue:
  • I am using Outlook 2016 Exchange
  • I have access to a shared calendar (with editor rights).
  • The owner of the shared calendar has most meetings color-coded using categories.
  • I would like the calendar I see to have a very different color scheme, using conditional formatting.
  • Outlook won't apply conditional formatting if a category color is set.
  • I cannot delete the category just on my version of the calendar (as far as I know - is that right?).
Best idea I can come up with:
  • Make a copy of the shared calendar
  • Delete all categories
  • Apply a view I have set with all the conditional formatting I want
Problems with my idea:
  • I would have to repeat this at least once a week, which is annoying and time-consuming.
  • In-week changes to the shared calendar would not be captured on my version of it
Questions for the experts:
  • Is my approach the only/best way to accomplish this?
  • If it is, could a macro take care of all these steps, including deleting the previous copy, making a new copy, deleting categories (and reminders?)
Any great ideas out there on this one?

Much appreciated!

Marc
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
I´m not an expert for Exchange permissions so I don´t know if this is possible: If you can remove your permission to read hidden items from the default calendar of the shared mailbox, then you wouldn´t see its colors. Without a color applied, you would get the conditional formatting back.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If you can remove your permission to read hidden items from the default calendar of the shared mailbox
i don't think you can... but what are the min. permissions required to see the owners colors?

I cannot delete the category just on my version of the calendar (as far as I know - is that right?).
Right.
Make a copy of the shared calendar
Yeah... or use a macro to do it daily. Create views for 'all calendar folders' and use the macro to delete the existing folder (for for this folder only would get deleted when the folder is deleted) and copy the items, removing the categories (its easier than checking each item or making dupes). i have a macro that does this with selected calendars- a few tweaks and it can copy just this shared calendar - Combine and Print Multiple Outlook Calendars
 

Marc S

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Thanks for the input.

Changing permissions does work to eliminate the color from the category, but the category itself is remains listed on each calendar entry, and conditional formatting still does not seem to work. (It works fine on entries with no category set, but not on entries with a category, even though no color shows - annoying).

Diane, thanks for the macro script! While duplicating a massive calendar everyday is not high on my list, seems like the best option. I will give it a shot.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Changing permissions does work to eliminate the color from the category, but the category itself is remains listed on each calendar entry, and conditional formatting still does not seem to work.
I was afraid of that - the "white" color overrides conditional formatting. You need to remove the categories completely.

The macro should make it easy to duplicate - especially if you can limit it to just a few days on either side of 'today'.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Just curious, which permission did you remove to get rid of the color?
 

Marc S

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
@Michael Bauer, I changed the READ permission to "Free/Busy time, Subject, Location". This changes the overall permission level to "Custom".
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
A Using OR when organising with conditional formatting Using Outlook 1
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 5
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
K Using Outlook 2016 to draw Using Outlook 1
O Outlook 365 - suddenly unable to send using Gmail POP3 Using Outlook 10
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
O Save attachments using hotkey without changing attributes Outlook VBA and Custom Forms 1
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
A Edit subject - and change conversationTopic - using VBA and redemption Outlook VBA and Custom Forms 2
A Using or not using apostrophes in search terms has this changed? Using Outlook 0
O Office 365 using POP3 on both laptop and desktop Using Outlook 0
M Using field names to capture a data element Using Outlook 0
B Vba to monitor time to respond to emails using a shared mailbox Outlook VBA and Custom Forms 5
B Looking to get the Recipient email address (or even the "friendly name") from an email I am replying to using VBA Outlook VBA and Custom Forms 4
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
O Using .OST and .PST mail thru different providers Using Outlook 5
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
D Remove text in subject using VBA Outlook VBA and Custom Forms 4
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
E Using the Like operator properly Outlook VBA and Custom Forms 1
R Using "check for duplicates" for existing contacts Using Outlook 2
S Find a cell value in excel using outlook vba Using Outlook 1
N Using email notification to update calendar events? Outlook VBA and Custom Forms 4
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
C Sync Calendars using WiFI Using Outlook 3
A Capturing Send Variables without using Application_ItemSend in ThisOutlookSession Outlook VBA and Custom Forms 8
L Using alpha numeric in email address Using Outlook 5
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
D Print Attachments only in selected emails using a macro Outlook VBA and Custom Forms 3
B query outlook using vba Outlook VBA and Custom Forms 13
e_a_g_l_e_p_i A question about installing office 2013 Pro and using my .pst from office 2010 Using Outlook 12
A Forward Outlook Email by Filtering using Macro Rule Outlook VBA and Custom Forms 44
O How to paste website content using a specific font and removing URLs Using Outlook 2
P Replying to calendar item using VBA Outlook VBA and Custom Forms 4
N Export details to a excel spreadsheet using macros Using Outlook 0
R Toggle the Reading Pane using Keyboard Shortcut Using Outlook 0
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
H Change Default Email Account Using VBA Outlook VBA and Custom Forms 5
S Outlook [Online - Office365] perfomance is getting affected when accessing the mails using Redemptio Using Outlook 1
M Using Outlook with Yahoo email Using Outlook 6

Similar threads

Top