- #Highlight domain in outlook conditional formatting how to#
- #Highlight domain in outlook conditional formatting code#
- #Highlight domain in outlook conditional formatting download#
Lets say, each event has 4 details associated with it – title, date, venue & description. Set up the formulas to show details when a valid date is selected Tutorial: Showing details when user selects a cell 6. If Not Application.Intersect(Target, Range("calendar")) Is Nothing Then Private Sub Worksheet_SelectionChange(ByVal Target As Range) Please attach it to the sheet where your calendar is. This will help us identify when user selects a cell in “calendar” range. We will use this to identify which date is selected by user. Select a blank cell in your workbook, give it a name like “selectedCell”. Assign a cell for identifying which date is selected Select all the cells in calendar range and give a name to it. At this stage, the calendar should look like this: So I just entered date of May 1st in a cell, dragged it sideways and then re-arranged the cells to make it look like a calendar.
In my case, all the events (Masterclass sessions) are in May & June 2013. If your events span several months, then you can use formulas to generate calendar. Just enter event data in a table like below:
#Highlight domain in outlook conditional formatting how to#
How to create an interactive calendar from a set of events 1.
#Highlight domain in outlook conditional formatting download#
If you live near any of these cities and want to become awesome in Excel, please consider enrolling in my Masterclass.Ĭlick here for details & to book your spot | Download Masterclass brochure Back to the interactive calendarĬoming back to our topic at hand – interactive calendar, what do we mean by this? We will be doing 2 day interactive sessions on Excel, advanced Excel, interactive charts, pivot tables & dashboards in Chicago, New York, Washington (DC) & Columbus (OH). But first, a reminder to join my Advanced Excel masterclass in USAĪs you may know, I am running my first ever Advanced Excel & Dashboards Masterclass in USA this summer (May / June 2013).
#Highlight domain in outlook conditional formatting code#
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. then Automatic Formatting button.One of the popular uses of Excel is to maintain a list of events, appointments or other calendar related stuff. Video tutorial: Outlook 2010 and newerĬlick on Arrange By to expand the menu and select Custom. To make a copy of the view, choose Save Current view as a New View from the Change View menu. If the original view gets messed up, use the copy and apply it to the folders. You can make a copy of the view thus is recommended if you customized a default view as it's very easy to accidently reset the view. To apply it to other folders, use Change View > Apply Current View to Other Mail Folders to set the view on other folders.
In all versions, right click on the row of field name (or Arrange By) at the top of the message list and choose Customize (or View Settings). In Outlook 2010 and newer, look for the View Settings button on the View tab. In this example, I'm highlighting messages from a sender in Red then creating a copy of the view so I can show only the messages from that sender.