Command Button to highlight cell on another sheet

[mpiper20]

Hi,
I'm looking to get a command button to highlight a cell on another page green with the text Pass in it.
So my command button is on sheet 3 (DEP01) and the cell I want to highlight green with the text in is C3 on sheet 1 (INDEX)
I've managed to highlight C3 and get text (seperately not together) but just not on the other sheet.

 

[AlphaFrog]

Qualify the sheet before the range e.g.

Private Sub CommandButton1_Click()
    Sheets("INDEX").Range("C3").Font.Color = vbGreen
End Sub

 

[mpiper20]

And then if I wanted to use the Macro to change the text to Pass?

 

[mpiper20]

Qualify the sheet before the range e.g.

Private Sub CommandButton1_Click()
    Sheets("INDEX").Range("C3").Font.Color = vbGreen
End Sub

And then if I wanted to use the Macro to change the text to Pass?