Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how do i change the selected cells color

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default how do i change the selected cells color

Put the following macro in worksheet code:

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

--
Gary''s Student
gsnu200709


"Asofio" wrote:

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?

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
How to change the color of selected cells in excel 2007 Selecting non-adjacent cells in Excel 07 Excel Discussion (Misc queries) 2 February 24th 07 09:10 PM
How to: Change color of column / row headers and selected menus? Mark Excel Discussion (Misc queries) 7 September 28th 06 11:51 PM
Excel 2003--How do I change the color of selected items? Munchichic Excel Discussion (Misc queries) 3 March 27th 06 08:11 PM
How can you change the color of the selected range? Andrew Excel Discussion (Misc queries) 2 June 30th 05 07:37 PM
How do I change the highlight color of selected menu items? PepperVL Excel Discussion (Misc queries) 1 March 12th 05 02:13 PM


All times are GMT +1. The time now is 04:53 AM.

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

About Us

"It's about Microsoft Excel"