Highlighting selected cells in 2007

J

Jeanne

Hi:

One thing I find a little frustrating in this new version of Excel is that
it does not highlight selected cells. When contiguous cells are selected
it's no problem but when non-contiguous cells are selected I can't see
selections. Any way to change this?

JC
 
D

Don Guillett

Mine does but it is light gray and hard to see.
Right click sheet tab>view code>insert this>change color index to whatever
desired.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 6
End With
End Sub
 
Top