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

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

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