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.

thank you very much for the VBA color help. the conditional formatting, however, will not work. I have attached my most recent model and now have another question with regards to the color of the cells D9, D13, A18, A20, A25, and A27 in the 'Game Summary' tab. I want to attempt to copy the color scheme of the respective team, but cannot figure it out using VBA. I attempted to use copy me language in VBA, copying the cell A19's formatting from the 'Chicago Bulls' tab, but it did not work. Please let me know if you can help me out. Thank you again!!!