Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Highlighting cells
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 |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Highlighting cells
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 "Will" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add cells by highlighting them? | Excel Discussion (Misc queries) | |||
Highlighting Cells | Excel Worksheet Functions | |||
highlighting cells | Excel Discussion (Misc queries) | |||
HIGHLIGHTING CELLS | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |