Changing the color of Cell Selection?
 

I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my computer
contrast settings does not help.

Changing the color of Cell Selection?
 

Hi,

Have a look at Chip Pearson's Rowliner addin

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

Mike

"ks" wrote:

I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my computer
contrast settings does not help.

Changing the color of Cell Selection?
 

This may be of some help. Copy and paste in the sheet module. Now whenever
you select a cell in the Range("B8:K22") that row from B to K will be
highlighted.

The range of highlighting and the color is easily changed to suit your
sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim j As Integer
Dim k As Integer
i = 2
j = 8
k = ActiveCell.Column()
Set Data = Range("B8:K22")

Data.Interior.ColorIndex = xlNone

If ActiveCell.Row < 8 Or ActiveCell.Row 22 Or _
ActiveCell.Column < 2 Or ActiveCell.Column 11 Then
Exit Sub
End If

ActiveCell.Offset(0, -(k - i)). _
Resize(1, 10).Interior.ColorIndex = 35

End Sub

HTH
Regards,
Howard

"ks" wrote in message
...
I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my
computer
contrast settings does not help.