#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default highlighted cell color

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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 11,058
Default highlighted cell color

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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default highlighted cell color

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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default highlighted cell color

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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default highlighted cell color

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007, Color of highlighted cells Henrik Kofoed Excel Discussion (Misc queries) 0 April 17th 07 05:28 PM
Change highlighted cursor BOX border color (appearance) in Excel J-girl Excel Worksheet Functions 0 January 24th 06 05:54 PM
How do I count cells that have are highlighted a certain color? NicoleE Excel Worksheet Functions 1 September 2nd 05 10:14 PM
Every cell is highlighted 5hulses Excel Discussion (Misc queries) 5 May 2nd 05 12:27 AM
Preview document in same color used in highlighted cells Need Some Help Excel Discussion (Misc queries) 0 January 5th 05 03:57 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"