Highlight Active Cell

D

Dave

Hello,

Thanks in advance.

How do I color (highlight) the active cell? Or color the
borders of the active cell?

Thanks again,

DP
 
D

David McRitchie

Hi Dave,
See Chip Pearson's
http://www.cpearson.com/excel/rowliner.htm

The RowLiner add-in allows you have Excel automatically draw
row and/or column lines around the active cell, making it easier
to view rows and columns, especially when gridlines are not visible.

Also note that when you select a cell that you will see
changes in row and column headers depending on version
in Excel 2000 the Letter for column header and the Number
for row header become bold in Excel with or w/o Rowliner.
-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
P

Paul B

Dave here is one way, put in worksheet code, you might also want to have a
look here at chip's addin
http://www.cpearson.com/excel/rowliner.htm


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' this procedure will remove any interior cell colors you have
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Top