Color Scheme Help

Hey guys,

Thanks in advance for the assistance. I have been having some trouble writing VBA code to have color of the cells B3:B16 in the Lottery tab in the model attached to change dynamically to match the respective color scheme in cells A1:A30 in the Opponent tab. I also am having trouble using VBA codes to dynamically change the border colors to match the ones defined in either the Opponent or NBA tabs.

One last thing is on the Chicago Bulls tab. Cells B21:B35 have a data validation and the roster changes dynamically. I want to be able to hide cell B35 (or any other cell in that data validation range) if there is not an entry A21:A35.

I appreciate the help.