vba code to highlight values across workbook based on list from first worksheet

[ceq]

All,

I am a beginner to vba and I am trying to figure out a code that will take the values from a list on worksheet 1, then automatically highlight those values on the following worksheets.

For example, imagine you have a stadium flattened out into 2D, you have the rows and seats arranged so starting on the left side with section 100-1 (seat number 1) and goes all the way around the entire stadium. This would be worksheet 2. On worksheet 1, you have a list of broken seats in the entire stadium. By selecting all of the broken seats at once, I'd like to see them highlighted on the second page.

I hope that made sense...

Thanks!

[ceq]

Any help would be appreciated!