Conditional Formatting based on Department of person received from?

Not open for further replies.


New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
Hi There. I work for multiple schools in a single public school district. I color-code my email inbox by which school the email was received from. (Rather by which school the email sender is at.) Currently what I do is make a Conditional Formatting rule that looks for "Messages From: Doe, John; Smith, Frank; etc" I manually put all of the people in there. I've streamlined this process so that it doesn't take too long. Unfortunately, staff often get added or removed from the different buildings, which means I have to rebuild my rules every couple of months. Also, my high school has so many staff, that I have to make 2 different rules to cover all the names. I've confirmed that the staff peoples' school building is ALWAYS listed under the "Department" properties of their Outlook Contact info. It's also listed under "Company." It would be sooo much easier if I could do something like, "Message From: Department=<Central High School>" Or something like that. It doesn't seem like this is possible 'out of the box' though.... Any ideas how I might make this work? I have Outlook 2016 which syncs up with 365. MS Exchange Server, I believe. Windows 10. -steve
Nothing in the address identifies the school? if they use format for addresses or the display names use Name (building) format, you could use either of them.

I have a macro that will categorize mail based on the contact's category. Then use the category to set the conditional formatting. It works on contacts - i think it would be too slow to get building info from the global address list. (assuming the building info is in the GAL).
Assign Categories to Messages using Contact Category
Thanks for the replies. Unfortunately the part of the email after "@" is identical for everyone.
I'll check out this VBA code. I'm not a computer programmer. I made a macro-enabled Word doc years ago. Outlook can't be too different.
Outlook can't be too different.
It doesn't have a vba editor and its a little more difficult because there are different forms. But once you have a macro, its easy enough to edit.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
N Help creating a VBA macro with conditional formatting to change the font color of all external emails to red Outlook VBA and Custom Forms 5
E Conditional formatting - when current account <> received account ? Using Outlook 3
P BCM conditional formatting BCM (Business Contact Manager) 5
S Conditional Formatting for messages in a Conversation thread Using Outlook 1
S Conditional Formatting in calendar part of To-Do Bar Using Outlook 1
S Conditional formatting problem with "is not empty" and categories Using Outlook 2
M Using conditional formatting on a shared calendar with categories Using Outlook 6
C Change default colors for conditional formatting Using Outlook 2
D Conditional formatting - font sizes Using Outlook 3
A Help creating macro for conditional formatting settings Using Outlook 8
B Conditional Formatting:How to use >1 value in a filter Using Outlook 7
A Using OR when organising with conditional formatting Using Outlook 1
J Conditional Formatting Upon My Reply Using Outlook 1
N lose conditional formatting when importing to Outlook 2010 Using Outlook 2
K Outlook 2010 conditional formatting Using Outlook 21
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
T Conditional dates in Outlook Calendar Exchange Server Administration 1
R CALENDAR conditional formating not consistent??? Using Outlook 1
M A plug in (or method) to keep email message formatting after it expires Using Outlook 1
C View doesn't refresh (fields or formatting) Using Outlook 1
V Can one change the formatting of email title blocks? Using Outlook 0
K Outlook tasks formatting Using Outlook 4
V Outlook Forms: Formatting a Label with 2 different styles Outlook VBA and Custom Forms 1
N How to remove signature formatting from Text in Word (accidentally taken from Outlook) Using Outlook 0
L Email to task without changin formatting Outlook VBA and Custom Forms 16
K Paste from Windows Clipboard then change font without losing formatting Outlook VBA and Custom Forms 1
Diane Poremsky Use Word Macro to Apply Formatting to Email Using Outlook 0
makinmyway How Prevent Re-Formatting of Contact Notes Field When Syncing Using Outlook 10
G outlook 13 copy & paste without losing formatting Using Outlook 1
D Outlook 2007 Formatting Using Outlook 1
D telephone formatting Contacts Using Outlook 2
A Lync meeting in outlook lose HTML formatting Using Outlook 3
Copwriter Paragraph formatting in blank messages/stationery Using Outlook 3
V Report stuck formatting page Using Outlook 1
T The Formatting Changes When A Recurring Appointment is Changed Using Outlook 1
J Formatting Contacts to Export for iPhone Using Outlook 0
O How do I get rid of odd formatting of new e-mails? Using Outlook 3
G Outlook 2010 not formatting in-line comments Using Outlook 5
W Outlook 2010 Share calendar but keep color formatting Using Outlook 2
Commodore Auto-formatting of certain phone numbers Using Outlook 2
B Ok - a complicated one - but really need help (auto formatting) Using Outlook 9
E Email Formatting - Tabs Using Outlook 1
A Need method to rapidly correct telephone contact telephone number formatting Using Outlook 1
H Formatting of email conversation print outs - URGENT Using Outlook 1
K Problems with message formatting for individual user Using Outlook 1
M Auto-correct Contact fields' formatting? Using Outlook 7
O Hyperlink formatting lost after replacement in outlook Using Outlook 5
O Hyperlink formatting lost after replacement in outlook Using Outlook 0
D Formatting Styles when Replying Using Outlook 10
N Help in programmatically setting formatting in an AppointmentItem Outlook VBA and Custom Forms 3

Similar threads