how to highlight the selected cell

[akschary]

Dear all
How to highlight the selected cell which is very usefull when we search a paticular cell in a large data so please any one tell me how to highlight

 

[AhoyNC]

You would use conditional formatting.

See the attached link on how to use it. If it doesn't answer your question you will need to give an actual example of what your conditions are.

https://www.youtube.com/watch?v=GRfe4bHsjhI

 

[L. Howard]

Assumes the sheet has no other color formatting on it, otherwise that will be deleted on first selection.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Cells.Interior.ColorIndex = xlNone
  ActiveCell.Interior.ColorIndex = 6
End Sub

If you have any interest in highlighting the entire row (or even just a predetermined number of cells across a row) that is quite possible.

Also, you could have "Large Block O Data-1" and somewhere else on the sheet have "Large Block O Data-2" and when you click in either Block O Data the row will be highlighted from left edge to right edge of that Block O Data boundaries.

Might be more than you need or want, but FYI.

Regards,
Howard

 

[akschary]

Thank u
yes i also need highlight entire row

 

[L. Howard]

Try this in the sheet module.
If you want the column also, uncomment that line.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  Cells.Interior.ColorIndex = xlNone
  ActiveCell.EntireRow.Interior.ColorIndex = 6
  'ActiveCell.EntireColumn.Interior.ColorIndex = 6
End Sub

Regards,
Howard