Query on Cell

[VIVEKMANE]

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

Please reply.......................

 

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