Highlight a row

  • Thread starter Thread starter Ultimate
  • Start date Start date
U

Ultimate

I want to be able to pick any cell on a particular sheet and have the
whloe row that it is in change to a a highlight or specific color. any
help would be appreciated. thanks.
 
This page of Chip Pearson's might interest you.

http://www.cpearson.com/excel/RowLiner.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I want to be able to pick any cell on a particular sheet and have the
whloe row that it is in change to a a highlight or specific color. any
help would be appreciated. thanks.
 
You may find that this is not exactly what you want, but I leave you t
sort that out <<grin>>.

'-----------------------------------------
Sub highlight()
With ActiveCell.EntireRow.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
End Sub
'-----------------------------------------
 
Back
Top