Row & Column selection Highlighting

bradjedis
4StarLounger
Posts: 540
Joined: 30 Mar 2010, 18:49
Location: United States

Row & Column selection Highlighting

Post by bradjedis »

Greetings!

Folks, I am using Excel 2007, and upon selecting a Row or Column, the row highlights a very faint color. Is there a way to change this highlighting?


Thanks,
Brad

User avatar
HansV
Administrator
Posts: 78594
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Row & Column selection Highlighting

Post by HansV »

The highlight color cannot be changed, but it should be a bright orange:
x104.png
If it isn't on your computer, it might be due to the video settings. You might try fiddling with the advanced settings of your video card, or with the contrast of your monitor.

If that doesn't help, you could use Jan Karel Pieterse's add-in FollowCellPointer (latest version attached to this post, or Chip Pearson's RowLiner Add-In. Both have the disadvantage of disabling the undo feature of Excel.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

bradjedis
4StarLounger
Posts: 540
Joined: 30 Mar 2010, 18:49
Location: United States

Re: Row & Column selection Highlighting

Post by bradjedis »

Thanks Hans.

I will take a look at the add-ins. (and yes, the Column and Row Headers turn the proper color). I am really meaning the entire Row selection color, not just the header cell of "A" or the Row Number itself.

Brad

User avatar
HansV
Administrator
Posts: 78594
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Row & Column selection Highlighting

Post by HansV »

I apologize for misinterpreting your question.

You can't change the background color for the selected range within Excel. It's a common complaint that this color is too light in Excel 2007, but it greatly depends on your video card/monitor.
Best wishes,
Hans

bradjedis
4StarLounger
Posts: 540
Joined: 30 Mar 2010, 18:49
Location: United States

Re: Row & Column selection Highlighting

Post by bradjedis »

No prob. I am glad you did not quite see what I meant. Now I have a cool add-in...

Thanks for the info.

Brad