Cell selection highlight colour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Avril S - 27 Mar 2008 13:03 GMT

Does anybody know if it is possible to change the colour and or contrast of
the cell selection highlight colour. This is where you wish to highlight
cells but not change thier colours in the spreadsheet. The highlight colour
contrast I am seeing on screen is too light. It makes no difference if I
change the vdu contrast and brightness settings.

Reply to this Message

Bob Phillips - 27 Mar 2008 13:14 GMT

One way, but it does wipe out all CF

'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'----------------------------------------------------------------
Cells.FormatConditions.Delete
With Target
With .EntireRow
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
.Interior.ColorIndex = 20
End With
End With
With .EntireColumn
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
With .FormatConditions(1)
With .Borders(xlLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
With .Borders(xlRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5
End With
.Interior.ColorIndex = 20
End With
End With

.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 36
End With

End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Does anybody know if it is possible to change the colour and or contrast
> of
[quoted text clipped - 3 lines]
> contrast I am seeing on screen is too light. It makes no difference if I
> change the vdu contrast and brightness settings.

Reply to this Message

Gord Dibben - 28 Mar 2008 01:11 GMT

Whereas Chip Pearson's customizable Rowliner add-in does not wipe out CF or
existing color formats.

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

Gord Dibben MS Excel MVP

>One way, but it does wipe out all CF
>
[quoted text clipped - 48 lines]
>'code module. To do this, right-click on the sheet tab, select
>'the View Code option from the menu, and paste the code in.

Reply to this Message

AS - 31 Mar 2008 09:29 GMT

Thanks guys - will try this out and see if it provides the solution. Shame
there is nothing in the standard functionlaity, as this was not an issue in
the 2003 version.

Signature

Avril S

> Whereas Chip Pearson's customizable Rowliner add-in does not wipe out CF or
> existing color formats.
[quoted text clipped - 55 lines]
> >'code module. To do this, right-click on the sheet tab, select
> >'the View Code option from the menu, and paste the code in.

Reply to this Message

Mike H - 27 Mar 2008 13:16 GMT

Hi,

You could use this addin

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

Mike

> Does anybody know if it is possible to change the colour and or contrast of
> the cell selection highlight colour. This is where you wish to highlight
> cells but not change thier colours in the spreadsheet. The highlight colour
> contrast I am seeing on screen is too light. It makes no difference if I
> change the vdu contrast and brightness settings.

Reply to this Message