So it will have an entry in "From:" field in format Name And in this case specifying the actual email in your conditional formatting rule will work correctly.Īlso, note that it is not possible to change this behavior as internal email addresses are resolved to names by Exchange and there is no setting to stop that from happening. Outlook will not be able to resolve the email to any known name or email alias. The situation with any external email, or any email unknown within the company network is different. Note that string comparison is not case sensitive, no wildcards allowed, however partial names are allowed. Hi, I'm facing a trouble in getting a separator/ comma in number column when conditional formatting is added. So matching your company email against contents of "From:" field will never return any positive results. I have an exchange calendar that has been shared via SharePoint / Comcast All of the conditional formatting was set up on each individual computer. Only the actual names can be found in "From:" field.Ĭonditional formatting does simple matching of given strings against contents of given fields. When you look at "From:" field you will realize that your email address is simply not there. You can simply check it by exporting the entire message to text format and opening it with your text editor. In your case it resolves to your name (won't be mentioning it in the post). Within the company, Outlook will resolve known emails to email alias or actual names. This will not work for you with your company internal email addresses. How can I make it work with simple email addresses ? If I set the "FROM" field ( via pressing "From." and select myself from a list) - with my outlook NAME which is "Royi Namir" ( as opposed to specify my direct email) as in here :Īm I missing something here ? because it should work in both cases.
In the Conditional Formatting dialog box, select Add to create a new rule. From your Calendar folder, select View > View Settings. Why don't I see the RED color in the work mail ? To set up conditional formatting rules for your calendar, use the following steps. Ok so let's test it by sending work mail to myself : This is particularly true with colors and conditional formatting. If you are saving it in the older Excel 97-2003 format, then it is possible that the losses you are seeing are due to the formatting not being supported in the older format. Roi's work emails sent to Roi's work ( i can send to myself) -> to be in red.Ĭurrently the settings are the default settings : First, you should make sure that your workbook is being saved in native Excel 2007/2010 format.Roi's Gmail emails sent to my Roi's work -> to be in green.I also have Gmail account which is outlook is under a domain I have outlook 2010 at my work where my email there is : ( you could see the real email in the pic, since I don't want crawlers to scan it, I changed it here in the question).