|First off, we can tell when you are lying to us. ;-)|
You can't have a cell named "mc1" or "mc2" since those are cell references and can't be used as a Range Name. Go ahead, try defining a name of mc1 and let us know what happens.
Now as far as your project, you should be able to do it with Conditional formatting as follows. (I was.)
Let's say your Named Ranges are A1:A4.
A1 is named band1
A2 is named band2
A3 is named emcee1
A4 is named emcee2
Let's your "Time Slots" are in B1:F100
1 - Eliminate the fill colors from the Named cells (A1:A4)
2 - Select A1:F100
3 - With all those cells selected, enter these Conditional Formatting rules, choosing a different fill color for each rule:
=A1=band1 (Pick a fill color)
=A1=band2 (Pick a fill color)
=A1=emcee1 (Pick a fill color)
=A1=emcee2 (Pick a fill color)
When you are done, all of your Named cells should turn the color you choose for that Name since they equal themselves and the CF formula will be TRUE.
In addition, any cell where the result of a formula matches the value in one of the Named cells, the CF will be TRUE and the formatting will match the formatting of the Named cell that the formula refers to.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.