Active cells stays highlighted

[gauravkrgautam]

Hi Ppls,

i am trying to highlight my activecell with skyblue color for the same i used event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

and it is working fine as i have instructed it and the i am unable to instruct is to reset its color while leaving cells as it is that is no fill.

attached file with sheet mine contains code. What i am missing in instruction please tell me?

many thanks in advance

 

[Somendra Misra]

Hi Gaurav,

See the file, it uses CF and macro, if this suits your requirement than increase the CF range.

Regards,

 

[Luke M]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Clear previous formatting
Cells.Interior.ColorIndex = xlNone
'Set new format
ActiveCell.Interior.ColorIndex = 37
End Sub

 

[NARAYANK991]

Hi Gaurav ,

Another option.

Narayan