Query on Cell
Try this simple worksheet event macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
ActiveCell.Interior.ColorIndex = 6
End Sub
REMEMBER: This goes in the worksheet code area, not a standatd module.
--
Gary''s Student - gsnu200760
"VIVEKMANE" wrote:
Is there any formula for : If we click on cell that cell should change its
color automatically.......
Please reply.......................
|