Perhaps you have used conditional formatting in Outlook to change the font size or color of your inbox list based on a condition you define. If you are using Outlook 2010, you may also apply conditional formatting to personal CRM views. Using conditional formatting for a CRM view in Outlook 2010 allows you to highlight important records regardless of the sort options applied to the view.
To illustrate this, l will create a personal view of open Opportunities where those with an estimated revenue of $100K or more display in a bold fuchsia font.
To create the personal view, navigate to the View tab of the Open Opportunities system view and click on Save As the ribbon:
A query properties box will open so that you may give the personal view a Name and Description. After entering the desired name and description, click on OK.
Your new personal view will open. Click on View Settings in the ribbon and then on Conditional Formatting:
Click on Add; a new rule for the view will be created:
Enter a Name for the rule:
Select the Color and Font style then click OK:
Click on Condition:
Click on Advanced, expand the Field criteria and then point to User-defined fields in folder:
Click on Est. Revenue (number):
Select the Condition, enter the Value and click on Add to List:
Click OK to save the changes to the filter:
Click OK to save the new rule:
Click OK to close the advanced view settings dialog box:
Your view will update to reflect the conditional formatting rule:
You may have noticed that on the list of user-defined fields the currency fields are listed multiple times; if you select one of these that is not appended with “(number),” it will act as a text field.
Conditional formatting of personal CRM views in Outlook 2010 is one option to personalize CRM to meet your needs.
This posting is provided “AS IS” with no warranties, and confers no rights.