Update: Jim Bob has sent a 17 minute screencast of his solution which includes another way to assign colors.
After watching Mark Miller's Screen-Cast, Color Code a SharePoint Calendar, I realized this was the perfect solution for transforming a payroll schedule on an Excel spreadsheet into a SharePoint Calendar to make it more visually appealing and user-friendly.
First Things First
Since I was beginning with a simple list of dates that was already color-coded, converting it to a calendar following Mark's screen-cast was a snap!
Payroll Schedule in Excel
Of course, the first task was to create a SharePoint Calendar, in three easy steps:
2. Create Calendar
3. New Calendar
Basic Payroll Calendar
Show Me the Money
The basic calendar is nice and you can display lots of useful information using it this way. But the payroll calendar is something that folks will look at often and the most important question is When do I get paid?
So, let's create some fields that will help us make Payday stand out, while providing color-coded information about some other important dates, as well.