How to reference cell color from a different Excel sheet?

Viewed 38

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.

Sheet1

Sheet2

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 
0 Answers
Related