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 |
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com