In a Shared Workbook of Excel, how do I change the color of a Cel.
Ahmed
Try putting this code on the sheet.
(Get into VBA and then Double-click on the sheet object)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.ColorIndex = 6
End Sub
Peter Bircher
"Ahmed" wrote in message
...
In a Shared Workbook of Excel, how do I change the color of a Cell by
simply
selecting it. For example, if I click on Cell B234 making it the Active
Cell, I want the color of Cell G234 to change to yellow.
|