G
George Ye
Guest
I am using Outlook 365 on a company Exchange server. All the activities I am outlining below is in the Outlook <g class="gr_ gr_27 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" data-gr-id="27" id="27">in</g> my computer, not the web app. I am wondering if there is a way to automatically <g class="gr_ gr_28 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="28" id="28">color</g> code received meeting invites by either organizer's or attendees' domain name via conditional <g class="gr_ gr_20 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="20" id="20">formating</g>?
For example, let's say there are three people in this meeting invite:
1) <g class="gr_ gr_32 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="32" id="32">Mr.</g> A, AAAAAA@domain1.com, who is the meeting organizer
2) <g class="gr_ gr_33 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="33" id="33">Ms.</g> B, BBBBBB@domain2.com, who is a required attendee
3) myself, me@domain1.com, who is also a required attendee
I would like to <g class="gr_ gr_21 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="21" id="21">setup</g> a conditional formatting rule such that, after I accepted the invite, the rule automatically changes the <g class="gr_ gr_35 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="35" id="35">color</g> of the meeting invite to, say bright orange, based on the fact that <g class="gr_ gr_34 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="34" id="34">Ms.</g> B comes from domain2.com.
I tried many ways without avail. Based on my research, I suspect it is because when I receive the meeting invite, <g class="gr_ gr_22 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="22" id="22">Ms.</g> B being a contact in <g class="gr_ gr_23 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="23" id="23">Mr.</g> A's address book, only the "Display Name" portion of <g class="gr_ gr_24 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="24" id="24">Ms.</g> B (aka "<g class="gr_ gr_25 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="25" id="25">Mrs.</g> B") is searchable by conditional formatting, despite that the actual email is listed right behind it in <> bracket. In other words, the actual email of <g class="gr_ gr_26 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="26" id="26">Ms.</g> B in the <> bracket seems to be not "visible" to conditional formatting search fields, when I tried to use field contain "domain2.com" approach.
Has anyone else encountered the same issue and found a way around it? Thanks for your help!
Continue reading...
For example, let's say there are three people in this meeting invite:
1) <g class="gr_ gr_32 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="32" id="32">Mr.</g> A, AAAAAA@domain1.com, who is the meeting organizer
2) <g class="gr_ gr_33 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="33" id="33">Ms.</g> B, BBBBBB@domain2.com, who is a required attendee
3) myself, me@domain1.com, who is also a required attendee
I would like to <g class="gr_ gr_21 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="21" id="21">setup</g> a conditional formatting rule such that, after I accepted the invite, the rule automatically changes the <g class="gr_ gr_35 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="35" id="35">color</g> of the meeting invite to, say bright orange, based on the fact that <g class="gr_ gr_34 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="34" id="34">Ms.</g> B comes from domain2.com.
I tried many ways without avail. Based on my research, I suspect it is because when I receive the meeting invite, <g class="gr_ gr_22 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="22" id="22">Ms.</g> B being a contact in <g class="gr_ gr_23 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="23" id="23">Mr.</g> A's address book, only the "Display Name" portion of <g class="gr_ gr_24 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="24" id="24">Ms.</g> B (aka "<g class="gr_ gr_25 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="25" id="25">Mrs.</g> B") is searchable by conditional formatting, despite that the actual email is listed right behind it in <> bracket. In other words, the actual email of <g class="gr_ gr_26 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation multiReplace" data-gr-id="26" id="26">Ms.</g> B in the <> bracket seems to be not "visible" to conditional formatting search fields, when I tried to use field contain "domain2.com" approach.
Has anyone else encountered the same issue and found a way around it? Thanks for your help!
Continue reading...