highlighted cell color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kdadman - 23 May 2007 19:09 GMT

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 to this Message

Gary''s Student - 24 May 2007 16:50 GMT

Try this little event macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub

Signature

Gary''s Student - gsnu200724

> 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 to this Message

kdadman - 24 May 2007 17:16 GMT

Thanks Gary, can you give me step by step how to use this macro, I can't seem
to get it to work.

> Try this little event macro:
>
[quoted text clipped - 9 lines]
> > 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 to this Message

Gord Dibben - 24 May 2007 18:14 GMT

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

>Thanks Gary, can you give me step by step how to use this macro, I can't seem
>to get it to work.
[quoted text clipped - 12 lines]
>> > 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 to this Message

Gord Dibben - 24 May 2007 18:38 GMT

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

>It is event code, not a macro.
>
[quoted text clipped - 25 lines]
>>> > 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 to this Message