Can anybody help me to fix this macro i have it to where is highlighting a single cell i will like the macro to highlight entire row base on a single cell value
thankyou for any help provided
![]()
Sub colorentirerow() 'base on a value of single cell highlight entire row Range("A1", ActiveCell.SpecialCells(xlLastCell)).Select For Each mycell In Selection If mycell.Value Like "5" Then mycell.Interior.ColorIndex = 3 End If Next End Sub
Bookmarks