Run Macro if cell contains "complete"

Hi All, I had a sheet that would change all of the text colour to a grey colour when a particular cell contained "complete".
I believe a macro was triggered, I see two macros in my old book but unsure which one i used or how I triggered it.
Would be very grateful if someone could solve this for me.

Macros listed here.

Sub GreyOut()
'
' GreyOut Macro
' Macro recorded 08/02/2007 by Russ Burke
'

'
Range("A3:O3").Select
Selection.Font.ColorIndex = 15
End Sub
Sub GreyOut2()
'
' GreyOut2 Macro
' Macro recorded 08/02/2007 by Russ Burke
'

'
Selection.Font.ColorIndex = 15
ActiveCell.Offset(0, 1).Range("A1").Activate
End Sub

many thanks

In that case please select Thread Tools from the menu link above and mark this thread as SOLVED.
.