Need help with conditional formating in a calendar

Douglas Edward

New Member
Joined
Jul 24, 2018
Messages
22
Office Version
  1. 2019
Platform
  1. Windows
I want to highlight the days in the calendar that match the days on the event list. Right now I'm using formula: =MATCH(B5,$AC$4:$AC$39,0), it applies to =$B$5:$X$37.
The problem is I can only highlight with one color. I want to use different colors for each location. (light green for Harding, Dark green for Wilson, ect.).
Is this possible?
 
Last edited by a moderator:

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Book1
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
120202020 Tournament Schedule for Griffith Park Golf Club & Griffith Park Senior Golf Club
2
3JanuaryFebruaryMarchAERATION SCHEDULEDateDayTimeLocationTournamentPlayers
4SMTWTFSSMTWTFSSMTWTFS4/3/2019Hansen DamFriday, January 3, 2020Friday7amWilsonNew Year's Super Skins60
51234112345674/17/2019WilsonSaturday, January 11, 2020Saturday7amHardingLeaning Tree Classic60
656789101123456788910111213145/7/2019EncinoWednesday, January 22, 2020Wednesday7amHarding3/6 Scramble32
7121314151617189101112131415151617181920215/8/2019HardingSaturday, February 8, 2020Saturday7amWilsonThe Bambino60
8192021222324251617181920212222232425262728Friday, February 21, 2020Friday7amWilson1457: Banned by Law60
926272829303123242526272829293031HolidaysBegins in MarchFourball Championship96
101/1/2020New Year's DaySaturday, March 7, 2020Saturday7amHardingThe Rogow72
111/20/2020Martin Luther King DayWednesday, March 18, 2020Wednesday7amHardingSt. Patty's Shamble84
12AprilMayJune2/12/2020Lincoln's BirthdayFriday, March 27, 2020Friday7amWilsonArnie's Army60
13SMTWTFSSMTWTFSSMTWTFS2/14/2020Valentine's DaySaturday, April 4, 2020Saturday7amWilsonGPGC 36 Hole Championship Day 184
141234121234562/17/2020Presidents DaySunday, April 5, 2020Sunday7amHardingGPGC 36 Hole Championship Day 284
155678910113456789789101112133/17/2020St. Patrick's DayFriday, April 24, 2020Friday7amHardingThe Didrikson32
161213141516171810111213141516141516171819204/10/2020Good FridaySaturday, May 2, 2020SaturdayIndian Canyons South8th Annual Palm Springs Desert Classic40
171920212223242517181920212223212223242526274/12/2020EasterSunday, May 3, 2020SundayDesert Willow Firecliff8th Annual Palm Springs Desert Classic40
182627282930242526272829302829305/5/2020Cinco de MayoFriday, May 15, 2020Friday7amHansen DamThe Dam60
19315/10/2020Mother's DaySaturday, May 30, 2020Saturday7amHardingMarty Tregnan Memorial84
205/25/2020Memorial DaySaturday, June 20, 2020Saturday7amWilsonThe Open84
21JulyAugustSeptember6/21/2020Father's DayWednesday, June 24, 2020Wednesday7amWilsonThe International60
22SMTWTFSSMTWTFSSMTWTFS7/4/2020Independence DayFriday, July 3, 2020Friday7amHardingRed White and Blue64
2312341123459/7/2020Labor DaySaturday, July 11, 2020Saturday7amEncinoEncino Man84
245678910112345678678910111210/12/2020Columbus DaySaturday, August 1, 2020Saturday7amHardingSNIEGOWSKI XI84
251213141516171891011121314151314151617181910/31/2020HalloweenWednesday, August 12, 2020Wednesday7amWilsonThe Tune-Up32
2619202122232425161718192021222021222324252611/11/2020Veterans' DayFriday, August 21, 2020Friday7amHarding83rd Club Championship Qualifier120
27262728293031232425262728292728293011/26/20200ThanksgivingSaturday, August 22, 2020Saturday7amWilson83rd Club Championship Qualifier120
28303112/25/2020Christmas DayFriday, September 4, 2020Friday7amWilsonThe Club Championship & Championship Sunday32
29Saturday, September 5, 2020Saturday7amHardingThe Club Championship & Championship Sunday16
30OctoberNovemberDecemberSunday, September 6, 2020Sunday7amWilsonThe Club Championship & Championship Sunday60
31SMTWTFSSMTWTFSSMTWTFSSaturday, September 19, 2020Saturday7amHardingFall Season Kickoff84
32123123456712345Saturday, October 3, 2020Saturday7amWilsonOktoberfest32
33456789108910111213146789101112Friday, October 16, 2020Friday7amWilsonThe President's Cup24
34111213141516171516171819202113141516171819Friday, October 16, 2020Friday1pmHardingThe President's Cup24
35181920212223242223242526272820212223242526Saturday, October 17, 2020Saturday7amWilsonThe President's Cup24
362526272829303129302728293031Friday, October 30, 2020Friday7amHardingHalloween84
37Saturday, November 14, 2020Saturday7amWilsonTurkey Shoot84
38Wednesday, November 25, 2020Wednesday7amHarding3 Club Challenge32
39Friday, December 11, 2020Friday7amWilsonChristmas Shotgun128
Sheet2
 
Upvote 0
You will need to setup a rule for each colour, along the lines of
="Wilson"=INDEX($AF$4:$AF$39,MATCH(B5,$AC$4:$AC$39,0),0)
 
Upvote 0
Simple and easy. I love it!

I didn't know about putting ="Wilson" before =INDEX

Thanks!
 
Upvote 0

Book1
BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
120202020 Tournament Schedule for Griffith Park Golf Club & Griffith Park Senior Golf Club
2
3JanuaryFebruaryMarchAERATION SCHEDULEDateTimeLocationTournamentPlayers
4SMTWTFSSMTWTFSSMTWTFSApril 3, 2019Hansen DamFriday, January 3, 20207amWilsonNew Year's Super Skins60
5123411234567April 17, 2019WilsonSaturday, January 11, 20207amHardingLeaning Tree Classic60
65678910112345678891011121314May 7, 2019EncinoWednesday, January 22, 20207amHarding3/6 Scramble32
712131415161718910111213141515161718192021May 8, 2019HardingSaturday, February 8, 20207amWilsonThe Bambino60
8192021222324251617181920212222232425262728Indian Canyons SouthFriday, February 21, 20207amWilson1457: Banned by Law60
926272829303123242526272829293031Desert Willow FirecliffSunday, March 1, 2020Fourball Championship96
10Saturday, March 7, 20207amHardingThe Rogow72
11HolidaysWednesday, March 18, 20207amHardingSt. Patty's Shamble84
12AprilMayJuneJanuary 1, 2020New Year's DayFriday, March 27, 20207amWilsonArnie's Army60
13SMTWTFSSMTWTFSSMTWTFSJanuary 20, 2020Martin Luther King DaySaturday, April 4, 20207amWilsonGPGC 36 Hole Championship Day 184
14123412123456February 12, 2020Lincoln's BirthdaySunday, April 5, 20207amHardingGPGC 36 Hole Championship Day 284
15567891011345678978910111213February 14, 2020Valentine's DayFriday, April 24, 20207amHardingThe Didrikson32
16121314151617181011121314151614151617181920February 17, 2020Presidents DaySaturday, May 2, 2020Indian Canyons South8th Annual Palm Springs Desert Classic40
17192021222324251718192021222321222324252627March 17, 2020St. Patrick's DaySunday, May 3, 2020Desert Willow Firecliff8th Annual Palm Springs Desert Classic40
18262728293024252627282930282930April 10, 2020Good FridayFriday, May 15, 20207amHansen DamThe Dam60
1931April 12, 2020EasterSaturday, May 30, 20207amHardingMarty Tregnan Memorial84
20May 5, 2020Cinco de MayoSaturday, June 20, 20207amWilsonThe Open84
21JulyAugustSeptemberMay 10, 2020Mother's DayWednesday, June 24, 20207amWilsonThe International60
22SMTWTFSSMTWTFSSMTWTFSMay 25, 2020Memorial DayFriday, July 3, 20207amHardingRed White and Blue64
231234112345June 21, 2020Father's DaySaturday, July 11, 20207amEncinoEncino Man84
2456789101123456786789101112July 4, 2020Independence DaySaturday, August 1, 20207amHardingSNIEGOWSKI XI84
2512131415161718910111213141513141516171819September 7, 2020Labor DayWednesday, August 12, 20207amWilsonThe Tune-Up32
26192021222324251617181920212220212223242526October 12, 2020Columbus DayFriday, August 21, 20207amHarding83rd Club Championship Qualifier120
272627282930312324252627282927282930October 31, 2020HalloweenSaturday, August 22, 20207amWilson83rd Club Championship Qualifier120
283031November 11, 2020Veterans' DayFriday, September 4, 20207amWilsonThe Club Championship & Championship Sunday32
2911/26/20200ThanksgivingSaturday, September 5, 20207amHardingThe Club Championship & Championship Sunday16
30OctoberNovemberDecemberDecember 25, 2020Christmas DaySunday, September 6, 20207amWilsonThe Club Championship & Championship Sunday60
31SMTWTFSSMTWTFSSMTWTFSSaturday, September 19, 20207amHardingFall Season Kickoff84
32123123456712345LA City EventsSaturday, October 3, 20207amWilsonOktoberfest32
33456789108910111213146789101112Friday, October 16, 20207amWilsonThe President's Cup24
34111213141516171516171819202113141516171819Friday, October 16, 20201pmHardingThe President's Cup24
35181920212223242223242526272820212223242526Saturday, October 17, 20207amWilsonThe President's Cup24
362526272829303129302728293031Friday, October 30, 20207amHardingHalloween84
37Saturday, November 14, 20207amWilsonTurkey Shoot84
38Wednesday, November 25, 20207amHarding3 Club Challenge32
39Friday, December 11, 20207amWilsonChristmas Shotgun128
Sheet2
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
Darn! I was trying to show you the result, but it dosen't show the conditional formating fill colors. It only shows the regular fill colors. (Which I still need to deleate. ha)
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top