Column and Row Color

[Spyros Macris]

For example, when you click on cell "B3", the column
heading "B" and row heading "3" change color. Does Excel
2003 offer any way to change that color in its existing
menus? Excel 2002 had a nice grey highlight, whereas
Excel 2003 has a bright orange that I do not like.

 

[Gord Dibben]

Spyros

That color would depend upon your Windows Display Scheme Settings.

Right-click on your Desktop and Properties>Themes.

Play with settings here.

Gord Dibben Excel MVP

 

[Gord Dibben]

Dave

You could do this with Conditional Formatting.

Select a range of row headers and Format>Conditional Formatting.

Formula is: =$A1="mb" choose a color from "Format" and OK

Click on "Add" button and do same for "sr"

You can have up to 3 Conditions(4 if you count the default no color)

Gord Dibben Excel MVP



On Mon, 26 Jul 2004 19:59:18 -0700, "Dave Merhar" <Dave

 

[TW]

I don't mean to dispute you, but I looked in the "Display
Properties"/Appearance/Advanced section and found no color there that
matched the color that Excel uses to highlight the row and column heading
names. Are there any settings in Excel that might affect this?

thnx
TED

 

[Gord Dibben]

TW

Re-read my original post.

The colors are set by a "Theme" under Properties>Themes, not
Properties>Appearance.

Any change made here will affect all applications.

There are no settings within Excel to alter.

Gord