set the background color of the current cell(active cell)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kang - 31 Jul 2007 06:12 GMT

how to set the background color the row of the current cell(active cell)
each time I click the cells.

Reply to this Message

Mike H - 31 Jul 2007 09:14 GMT

Hi,

Right click the sheet tab, view code and paste this in.

Public OldRange As Range
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not OldRange Is Nothing Then
OldRange.Interior.ColorIndex = xlNone
End If
Target.Interior.ColorIndex = 36
Set OldRange = Target
End Sub

Mike

> how to set the background color the row of the current cell(active cell)
> each time I click the cells.

Reply to this Message

Gord Dibben - 31 Jul 2007 16:48 GMT

Download Chip Pearson's RowLiner add-in to gain this functionality.

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

Gord Dibben MS Excel MVP

>how to set the background color the row of the current cell(active cell)
>each time I click the cells.

Reply to this Message

Rate this thread: