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.

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.

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.

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.

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.