MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
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
Posted : 24/02/2010 9:29 am
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")
Posted : 24/02/2010 9:39 am
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
Posted : 24/02/2010 9:44 am