Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
KS KS is offline
external usenet poster
 
Posts: 33
Default Changing the color of Cell Selection?

I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my computer
contrast settings does not help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Changing the color of Cell Selection?

Hi,

Have a look at Chip Pearson's Rowliner addin

http://www.cpearson.com/excel/RowLiner.htm

Mike

"ks" wrote:

I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my computer
contrast settings does not help.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 698
Default Changing the color of Cell Selection?

This may be of some help. Copy and paste in the sheet module. Now whenever
you select a cell in the Range("B8:K22") that row from B to K will be
highlighted.

The range of highlighting and the color is easily changed to suit your
sheet.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim j As Integer
Dim k As Integer
i = 2
j = 8
k = ActiveCell.Column()
Set Data = Range("B8:K22")

Data.Interior.ColorIndex = xlNone

If ActiveCell.Row < 8 Or ActiveCell.Row 22 Or _
ActiveCell.Column < 2 Or ActiveCell.Column 11 Then
Exit Sub
End If

ActiveCell.Offset(0, -(k - i)). _
Resize(1, 10).Interior.ColorIndex = 35

End Sub

HTH
Regards,
Howard

"ks" wrote in message
...
I can barley see the cells I select. How do I change the color of cell
selection so I can see what I am trying to highlight? Adjusting my
computer
contrast settings does not help.



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
Cell Range Selection Color WCMOUSER Excel Discussion (Misc queries) 1 October 18th 08 04:51 PM
drop down list that changes cell color upon selection Jay Excel Discussion (Misc queries) 13 June 6th 08 09:52 AM
How can I darken the cell selection highlight color JBIBelt Excel Discussion (Misc queries) 3 April 29th 08 04:53 PM
Changing selection color Tony Excel Discussion (Misc queries) 4 July 26th 07 02:20 PM
Change Cell background color by selection Bob Wall Excel Worksheet Functions 1 August 27th 06 02:13 AM


All times are GMT +1. The time now is 01:41 PM.

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"