Excel - automatically row highlight like manualy highlighted

[Bhaskar01]

I want to know - how to highlight a row (or selected row cells) automatically, when any of the cell is filled with any data...!! Please provide your thoughts..!! the row should be highlighted when i go to the next row - like mannually highlighted if its by macro - pls let know the code as i tried on what i know but was unable...

<tbody>
</tbody>

thanks,
Bhaskar

 

[L. Howard]

Try this code as a test. It highlights the selected cell row from column B to G within the Range("B8:G25).
This is easily enlarged as needed.

Copy and paste code in sheet module.

Regards,
Howard

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim k As Integer
i = 2
k = ActiveCell.Column()
Set Data = Range("B8:G25")
Data.Interior.ColorIndex = xlNone
If ActiveCell.Row < 8 Or ActiveCell.Row > 25 Or _
    ActiveCell.Column < 2 Or ActiveCell.Column > 7 Then
       MsgBox "Out of range", vbOKOnly, "Booger Snot" & " !" & " !"
    Exit Sub
End If
ActiveCell.Offset(0, -(k - i)). _
  Resize(1, 6).Interior.ColorIndex = 35
End Sub

 

[kevatarvind]

try below code in worksheet module it will highlight selected cell row

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
 Rows.Interior.ColorIndex = 0
 Target.EntireRow.Interior.ColorIndex = 6
End Sub