Hi,
I've used a couple of tutorials on conditional formatting relating to event calendars but I want to do something slightly different.
I Manage a football club and I want to be able to view 3 months events. I'd like the boxes to be green for home games and Red for away, but also add another colour for funraisers and another for meetings.
It was easy to get the box to turn green when the date existed in a specific column on another sheet but that's as far as I can get.
I've tried MATCH, VLOOKUP and AND others but I'm still scratching my head.
Sheet1, Data contains
Round,Date,Event Type,Opposition
1,01/02/2012,H,Team A
2,08/02/2012,A,Team B
3,15/02/2012,H,Team C
,22/02/2012,F,Fundraiser
,24/02/2012,M,Meeting
Sheet2 Data contains a basic calendar
Mon,Tue,Wed,Thu,Fri,Sat,Sun
01/02,02/02,03/02,04/02,05/02,06/02,07/02
Event Data
08/02,09/02,10/02.......
If I work out how to upload the file, I'm sure it would help.
Cheers
Andy
Bookmarks