Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 27th 07, 07:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 34
Default How do I change colors on the row/column active header?

When active I've seen the row and column header buttons a different color
than the rest of the header buttons. How do I turn on this feature? Right
now the buttons become bold but I'v eseen the entire button go from grey to
blue.

  #2   Report Post  
Old September 27th 07, 07:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default How do I change colors on the row/column active header?

If you select any cell the row and column headers for that cell will turn color.

If you select a row or column header that header will turn black.

This is default behaviour for versions <2007.

I do not have 2007 so can't speak for that.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 11:28:01 -0700, GaryW
wrote:

When active I've seen the row and column header buttons a different color
than the rest of the header buttons. How do I turn on this feature? Right
now the buttons become bold but I'v eseen the entire button go from grey to
blue.


  #3   Report Post  
Old September 27th 07, 08:01 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 34
Default How do I change colors on the row/column active header?

Well if by default that is supposed to be the case then somehow mine got
turned off. Any idea on how to turn it back on?

"Gord Dibben" wrote:

If you select any cell the row and column headers for that cell will turn color.

If you select a row or column header that header will turn black.

This is default behaviour for versions <2007.

I do not have 2007 so can't speak for that.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 11:28:01 -0700, GaryW
wrote:

When active I've seen the row and column header buttons a different color
than the rest of the header buttons. How do I turn on this feature? Right
now the buttons become bold but I'v eseen the entire button go from grey to
blue.



  #4   Report Post  
Old September 27th 07, 08:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default How do I change colors on the row/column active header?

What version?

I have heard that version 2007 has very weak highlighting colors.

Otherwise, there is no magic button or option to turn the default behaviour back
on.

What color scheme are you using in DesktopPropertiesAppearance?

Maybe make a change there.

I use the Windows Classic Theme and Windows Standard Color Scheme which gives me
gray headers that turn to blue when a cell is selected.


Gord


On Thu, 27 Sep 2007 12:01:01 -0700, GaryW
wrote:

Well if by default that is supposed to be the case then somehow mine got
turned off. Any idea on how to turn it back on?

"Gord Dibben" wrote:

If you select any cell the row and column headers for that cell will turn color.

If you select a row or column header that header will turn black.

This is default behaviour for versions <2007.

I do not have 2007 so can't speak for that.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 11:28:01 -0700, GaryW
wrote:

When active I've seen the row and column header buttons a different color
than the rest of the header buttons. How do I turn on this feature? Right
now the buttons become bold but I'v eseen the entire button go from grey to
blue.






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 I can change colour of row and column which are active ? hb Excel Discussion (Misc queries) 1 September 18th 06 01:49 PM
Excel 2003 color of active row and column header ydenne Excel Discussion (Misc queries) 2 May 15th 06 06:11 PM
How to set highlight for the column&row header of the active cell Jasmine Excel Worksheet Functions 1 January 14th 06 03:33 PM
Active Row Column Color Change Kim Setting up and Configuration of Excel 3 October 27th 05 04:49 PM
Active row and column header color Tony G Excel Discussion (Misc queries) 5 May 23rd 05 08:10 PM


All times are GMT +1. The time now is 03:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017