Excel color palette

Topic

New Reply

Hi,

For Win XP, O’2003 Uk

If I manually modify my color palette in Excel (Tools, Options, Color) – where will these changes then be stored?

Reply | Quote

Replies

In the active workbook. Each workbook has its own color palette (which starts out as the default palette).

Reply | Quote

I believe they are stored with the workbook, each able to have its own pallete of colors. Thus if a sheet from one workbook is copied into another the color of the items will change to reflect the pallete in that workbook

Steve

Reply | Quote

Just needed a “mind refresh”.

Thanks.

Reply | Quote

I am encountering trouble with color palettes on many workbooks. I was advised to use the Reset button on the color options. It does nothing. The defect causes a dark blue/gray background on many rows and cells, making black text almost invisible. I’ve tried this many times and the Reset approach never works. Thanks for any advice.

Reply | Quote

Could you attach a small workbook that exhibits this problem? You can remove most or all contents.

Reply | Quote

Look at the color pallet on this one..same as in my book.xls in startup. The pallet in Options does not seem correct and yet it will not “reset”. When I open up workbooks from others, I get this type of pallet. I know they do not send them wiht this fill color. Thanks.

Reply | Quote

Which version of Excel are you using?
When I open your sample workbook in Excel 2002 (XP), it has the default color palette:

Reply | Quote

Which version of Excel are you using?
When I open your sample workbook in Excel 2002 (XP), it has the default color palette:

That’s incredible. That’s not what I’m seeing a this end. That looks like what it should be, but I do not get that palette. We are currently using 2003 in XP, but are getting 2007 files from other people. Here is an image of what I see everywhere. Any suggestions? Could it be a hardware issue?

Reply | Quote

Does this just happen with workbooks that were originally created in Excel 2007 or also with workbooks that you create in Excel 2003.

Reply | Quote

Most of our files are still created in 2003.

Reply | Quote

Either there is something wrong with your video card, or else with your installation of Excel.

What happens if you select a color then click Modify…? Do you get normal-looking colors as in this screenshot, or distorted/flat colors?

Reply | Quote

I see the same color fields in both tabs as you show. Amazing. Yet the pallets in the workbooks are missing colors. Is there any macro to reset? Why do you think that reset button doesn’t work? because there’s nothing wrong with the pallet in the options tab? guess so. If I were to “customize” the “bad pallets” in specific workbooks back to defaults, woud that eliminate the color problem? Can I be shown which of those colors I should select in the rebuild? Thanks.

Reply | Quote

You can try importing the color palette from a workbook that has a normal palette. Both workbooks must be open for this.

Reply | Quote

You can try importing the color palette from a workbook that has a normal palette. Both workbooks must be open for this.

Can you give me the steps? I don’t see anything in the menus about such a process. BTW I just had someone send me from their laptop a workbook with a good color pallett. When I opened it up on my laptop….bad palette! Is there any way to test my on-board video for this?

Reply | Quote

Open a “problem” workbook and a worbook with a “normal” color palette.
Activate the problem workbook.
Select Tools | Options…
Activate the Color tab.
Click the dropdown arrow of the “Copy colors from” dropdown list (it’s shown in post #9 higher up in this topic).
Select the workbook that has a correct color palette.

Reply | Quote

Open a “problem” workbook and a worbook with a “normal” color palette.
Activate the problem workbook.
Select Tools | Options…
Activate the Color tab.
Click the dropdown arrow of the “Copy colors from” dropdown list (it’s shown in post #9 higher up in this topic).
Select the workbook that has a correct color palette.

I’m back about this problem. Many folks on my team now have it. Is there a way to write a macro to reset the color palette by using the ColorIndex number and forcing the whole palette in the book to reset that way? I think there are only 56 colors in the ’03 palette. Thanks!

Reply | Quote

The Reset button in the Color tab of the Options dialog should reset the palette to the factory default, but apparently it doesn’t for you, so I’m not sure this will work:

Code:

Sub ResetColors()
  Application.ScreenUpdating = False
  With ActiveWorkbook
	.Colors(1) = 0
	.Colors(2) = 16777215
	.Colors(3) = 255
	.Colors(4) = 65280
	.Colors(5) = 16711680
	.Colors(6) = 65535
	.Colors(7) = 16711935
	.Colors(8) = 16776960
	.Colors(9) = 128
	.Colors(10) = 32768
	.Colors(11) = 8388608
	.Colors(12) = 32896
	.Colors(13) = 8388736
	.Colors(14) = 8421376
	.Colors(15) = 12632256
	.Colors(16) = 8421504
	.Colors(17) = 16751001
	.Colors(18) = 6697881
	.Colors(19) = 13434879
	.Colors(20) = 16777164
	.Colors(21) = 6684774
	.Colors(22) = 8421631
	.Colors(23) = 13395456
	.Colors(24) = 16764108
	.Colors(25) = 8388608
	.Colors(26) = 16711935
	.Colors(27) = 65535
	.Colors(28) = 16776960
	.Colors(29) = 8388736
	.Colors(30) = 128
	.Colors(31) = 8421376
	.Colors(32) = 16711680
	.Colors(33) = 16763904
	.Colors(34) = 16777164
	.Colors(35) = 13434828
	.Colors(36) = 10092543
	.Colors(37) = 16764057
	.Colors(38) = 13408767
	.Colors(39) = 16751052
	.Colors(40) = 10079487
	.Colors(41) = 16737843
	.Colors(42) = 13421619
	.Colors(43) = 52377
	.Colors(44) = 52479
	.Colors(45) = 39423
	.Colors(46) = 26367
	.Colors(47) = 10053222
	.Colors(48) = 9868950
	.Colors(49) = 6697728
	.Colors(50) = 6723891
	.Colors(51) = 13056
	.Colors(52) = 13107
	.Colors(53) = 13209
	.Colors(54) = 6697881
	.Colors(55) = 10040115
	.Colors(56) = 3355443
  End With
  Application.ScreenUpdating = True
End Sub

Reply | Quote

Seems to work. Thanks.

Reply | Quote