Calendar Population

**filmnoir** · 04-13-2012, 04:50 AM

Here's an unusual one that has me stumped....

On the sheet data I want to add a date and meeting name.

On Calendar, I want the data highlighted and the meeting name written in details.

calendar.xls

Any ideas welcome!

**WinteE** · 04-13-2012, 06:20 AM

See the attached file. There is a Conditional format added to April and May, the other months need to be done.

**filmnoir** · 04-13-2012, 06:49 AM

Ahh ok I see how that works, using the Vlookup. How do I relicate the Formula Is Conditional Formatting without doing it for each individual date?

Many Thanks

**WinteE** · 04-13-2012, 07:05 AM

Create a Conditional Format for the first field of a month and copy the Conditional code to it. You can copy that field to each day in the month.
You'll have to do this separate for each month.
When you click on a highlighted field the event name is displayed in the 'Detail' range.