Query on Cell

V

VIVEKMANE

Is there any formula for : If we click on cell that cell should change its
color automatically.......

Please reply.......................
 
G

Gary''s Student

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.
 
Top