Synchronize excel calendar with dates

Hello.

Here is what I am looking to do: on one sheet of my workbook is an activity log. Users will plug in a date and in the next cell they will record an activity. On the second sheet I would like to have a yearly calendar. When the user plugs in, say 1/1/2012 and logs activity, the calendar will update. After logging an event, that date's cell will change colors on the second sheet.

Example:
On 12/5/2012 an employee was absent.
The cell for 12/5/2012 on the calendar is now filled in red.

On 12/1/2012 an employee was tardy
The cell for 12/1/2012 is now filled in yellow.


Any thoughts on how to accomplish this?

If you're looking to capture data from one input cell and log it, you'll need a macro to do this. Let us know what cell the data is being captured in, where the "calendar" range is, and where you'd like the data pasted. (I.e. one column to the right of the date?)

To highlight the data in the calendar, you'll just want to set up a conditional formatting rule.