I'm trying to have the cell in Sheet1 check the corresponding cell in Sheet2 and turn into that cell color (or red) if that cell color is red.
For the people in Automotive in Sheet1, go to Sheet to to check on the # of Previous Jobs. If that cell is colored red, also turn red.


Something like below, but I'm not sure how to get started with VBA
For Job_Subjects=Automotive
If Cell2.Interior.Color=255
Then Cell2.Interior.Color=255
End Sub