Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
In Excel 2007 when I click and highlight a croup of cells, the background
color is "annoying". How can I change it so whenever I select a group of cells they are highlighted in a color I would prefer. I know I can change the background of cells, I just want to change the color that they turn whenever any cells in the workbook are highlighted. |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Try this little event macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub -- Gary''s Student - gsnu200724 "kdadman" wrote: In Excel 2007 when I click and highlight a croup of cells, the background color is "annoying". How can I change it so whenever I select a group of cells they are highlighted in a color I would prefer. I know I can change the background of cells, I just want to change the color that they turn whenever any cells in the workbook are highlighted. |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Thanks Gary, can you give me step by step how to use this macro, I can't seem
to get it to work. "Gary''s Student" wrote: Try this little event macro: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub -- Gary''s Student - gsnu200724 "kdadman" wrote: In Excel 2007 when I click and highlight a croup of cells, the background color is "annoying". How can I change it so whenever I select a group of cells they are highlighted in a color I would prefer. I know I can change the background of cells, I just want to change the color that they turn whenever any cells in the workbook are highlighted. |
#4
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
It is event code, not a macro.
Right-click on the sheet tab and "View Code". Copy/paste the code into that sheet module. Any cell or cells selection will cause the cell(s) to become yellow. Just a note: if you have previously colored cells with a background color, this code will wipe out that background. Gord Dibben MS Excel MVP On Thu, 24 May 2007 09:16:02 -0700, kdadman wrote: Thanks Gary, can you give me step by step how to use this macro, I can't seem to get it to work. "Gary''s Student" wrote: Try this little event macro: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub -- Gary''s Student - gsnu200724 "kdadman" wrote: In Excel 2007 when I click and highlight a croup of cells, the background color is "annoying". How can I change it so whenever I select a group of cells they are highlighted in a color I would prefer. I know I can change the background of cells, I just want to change the color that they turn whenever any cells in the workbook are highlighted. |
#5
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
If the wiping out part is not desireable I would suggest you use Chip Pearson's
Rowliner Add-in which preserves original formatting whilst coloring the activecell. http://www.cpearson.com/excel/RowLiner.htm Gord On Thu, 24 May 2007 10:14:37 -0700, Gord Dibben <gorddibbATshawDOTca wrote: It is event code, not a macro. Right-click on the sheet tab and "View Code". Copy/paste the code into that sheet module. Any cell or cells selection will cause the cell(s) to become yellow. Just a note: if you have previously colored cells with a background color, this code will wipe out that background. Gord Dibben MS Excel MVP On Thu, 24 May 2007 09:16:02 -0700, kdadman wrote: Thanks Gary, can you give me step by step how to use this macro, I can't seem to get it to work. "Gary''s Student" wrote: Try this little event macro: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlNone Target.Interior.ColorIndex = 6 End Sub -- Gary''s Student - gsnu200724 "kdadman" wrote: In Excel 2007 when I click and highlight a croup of cells, the background color is "annoying". How can I change it so whenever I select a group of cells they are highlighted in a color I would prefer. I know I can change the background of cells, I just want to change the color that they turn whenever any cells in the workbook are highlighted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007, Color of highlighted cells | Excel Discussion (Misc queries) | |||
Change highlighted cursor BOX border color (appearance) in Excel | Excel Worksheet Functions | |||
How do I count cells that have are highlighted a certain color? | Excel Worksheet Functions | |||
Every cell is highlighted | Excel Discussion (Misc queries) | |||
Preview document in same color used in highlighted cells | Excel Discussion (Misc queries) |