Using Drop-Down list with offset

what do you mean what happened to the chicago bulls?

the most recent model I attached is the one that is correct. I just want to figure out how to use VBA to extract the border colors from the team name cells in the NBA tab and how to somehow blank the last drop down option (in B35) when there is nothing in A35.

does anyone know how to format row 35 so that if A35 is blank, the data validation entry in B35 will also be blank? also, does anyone know to use VBA so that the border color for cell A19 on the Chicago Bulls tab follows the border color of the respective team listed on the NBA tab? Thank you very much.