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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks