ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change colors on the row/column active header? (https://www.excelbanter.com/excel-worksheet-functions/159954-how-do-i-change-colors-row-column-active-header.html)

Garyw

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.

Gord Dibben

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.



Garyw

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.




Gord Dibben

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.






All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com