How do I change the color of a cell on one worksheet based on the color of a
different tab worksheet? Example. I have cell A3 on Worksheet 1, and I want
it to change based on the tab color of worksheet 3.

Thanks,

Worksheets(3).Tab.ColorIndex

"Michael" wrote:

How do I change the color of a cell on one worksheet based on the color of a
different tab worksheet? Example. I have cell A3 on Worksheet 1, and I want
it to change based on the tab color of worksheet 3.

Thanks,

Here is an example


Private Sub CommandButton1_Click()
Sheets(1).Select
Range("A1").Select
ActiveCell.Interior.ColorIndex = Worksheets(3).Tab.ColorIndex
End Sub