Click OK buttons successively to close all dialog boxes.Īnd now all appointments meeting the specified filter criteria have been highlighted with your selected color automatically. In my example, I set the filer criteria as subject contains the specified text of test, see screenshot:ĥ. In the Filter dialog box, please add the specified filter criteria that you will automatically highlight appointments based on. (3) Specify a color from the Color drop down list Ĥ. + vbInformation Else MsgBox Appointment not found at & Format(dtCheck. In the second dropdown, choose Today (Figure A). Dear All, I am trying to create a vba to add appointments to Outlook 2010. In the lower pane, choose Dates Occurring from the first dropdown. In the resulting dialog box, choose Format Only Cells That Contain in the upper pane. (2) Type a name for the now color rule in the Name box On the Home tab, click Conditional Formatting in the Styles group. Now you get into the Conditional Formatting dialog box, please do as following screenshot shown: to specify the font characteristics that Outlook for Microsoft.
In the opening Advanced View Settings dialog box, please click the Conditional Formatting button.ģ. Conditional formatting in Outlook In the Name box, type a name of the new rule Click Font. In the Calendar view, select the calendar you will automatically highlight appointments, and click View > View Settings.Ģ.
But we can use little creativity, conditional formatting, few formulas & 3 lines of VBA code to create a slick, interactive calendar in Excel.
While Excel shines easily when you want to log this data, it has no quick way to visualize this information.
Please click to highlight the Unread messages in the Rules for this view list box, and click the Font button. One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff. Now it opens the Conditional Formatting dialog box. If you want to automatically highlight multiple appointments if meeting specified criteria in an Outlook calendar, you can color code these appointments with conditional formatting as follows:ġ. In the opening Advanced View Settings dialog box, please click the Conditional Formatting button.