Highlighting cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Will - 15 Apr 2008 16:52 GMT

Excel 2007 sp1 with vista 32 business sp1

Background: When you highlight multiple non-contigious cells (i.e. hold the
control key down and select several cells that are not connected) Excel
highlights the selected cells in light blue.

Problem: This light blue does not show at all on many projectors. In some
case you can adjust the color temp and this helps. We do hundreds of
presentation in North America each year and can not control what projection
equipment we will be using.

Requested solution: I would change the light blue background that is applied
to selected cells to some other color or alternatively making the color
darker would probably work. Can this default setting be changed.

Thanks, Will

Reply to this Message

Office_Novice - 15 Apr 2008 18:46 GMT

In the Workbook Object paste this.
'This will go cell by cell if your cells color is light blue then it will
change to green.

Option Explicit

'This will tell you what number your color is.
Sub CheckColorIndex()
MsgBox ActiveCell.Interior.ColorIndex 'To determine your color
Color
End Sub

Sub Color()

Application.ScreenUpdating = False
Do
On Error GoTo NextColumn
ActiveCell.Offset(1, 0).Select
'The number from above
goes here
If ActiveCell.Interior.ColorIndex = 33 Then '<--is light blue but yours
could be differnt
ActiveCell.Interior.ColorIndex = 4 '<--- This is green
End If
Loop
NextColumn:
ActiveCell.Offset(-65535, 1).Select
Color
End Sub

> Excel 2007 sp1 with vista 32 business sp1
>
[quoted text clipped - 12 lines]
>
> Thanks, Will

Reply to this Message