Is it possible to be able to click in to a cell and get others to change colour or highlight the text. For example click in to A1 and at that point B3 & C5 turn green.
If so can someone point the right way as I can not even think of what to search on. Thanks

conditional format the cells you want to change colour using if cell value is equal to ?? (I generally use my initials "TM").

Then you'll need to create an if function in the original cell.

=IF(A1<=1,"TM")

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

Set A = Range("A1")

If ActiveCell = A Then

Range("B3,C5").Select
Selection.Interior.ColorIndex = 4

Else: End If

End Sub