the number of cell shade colors reduced
 

For some reason the number of cell shade colors reduced in my pattern
choices. It's related to a spreadsheet and it did it by itself. Anyone know
how to get the colors back?

the number of cell shade colors reduced
 

David

Reduced to how many?

There are only 56 to start with.

Just the one workbook?

When you open a blank workbook how many colors do you have?

If the blan book has all the colors, leave it open and open the "bad" workbook.

Go to ToolsOptionsColor and "Copy colors from".

Select the "good" workbook from the dialog box and OK.

Save the "bad" workbook.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:11:02 -0700, David Maerzke
wrote:

For some reason the number of cell shade colors reduced in my pattern
choices. It's related to a spreadsheet and it did it by itself. Anyone know
how to get the colors back?

the number of cell shade colors reduced
 

Thanks Gord! I actually went into Tools, Options, Color and clicked Reset
and they came back.
They weren't so much gone as a much lighter shade. The light green had
turned biege and red was black. Most unhelpful as a conditional formatting
highlight feature.

"Gord Dibben" wrote:

David

Reduced to how many?

There are only 56 to start with.

Just the one workbook?

When you open a blank workbook how many colors do you have?

If the blan book has all the colors, leave it open and open the "bad" workbook.

Go to ToolsOptionsColor and "Copy colors from".

Select the "good" workbook from the dialog box and OK.

Save the "bad" workbook.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:11:02 -0700, David Maerzke
wrote:

For some reason the number of cell shade colors reduced in my pattern
choices. It's related to a spreadsheet and it did it by itself. Anyone know
how to get the colors back?

the number of cell shade colors reduced
 

David

Good stuff.

Someone had been doing some mods in there from the sounds of it.


Gord

On Thu, 3 Aug 2006 17:58:01 -0700, David Maerzke
wrote:

Thanks Gord! I actually went into Tools, Options, Color and clicked Reset
and they came back.
They weren't so much gone as a much lighter shade. The light green had
turned biege and red was black. Most unhelpful as a conditional formatting
highlight feature.

"Gord Dibben" wrote:

David

Reduced to how many?

There are only 56 to start with.

Just the one workbook?

When you open a blank workbook how many colors do you have?

If the blan book has all the colors, leave it open and open the "bad" workbook.

Go to ToolsOptionsColor and "Copy colors from".

Select the "good" workbook from the dialog box and OK.

Save the "bad" workbook.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 17:11:02 -0700, David Maerzke
wrote:

For some reason the number of cell shade colors reduced in my pattern
choices. It's related to a spreadsheet and it did it by itself. Anyone know
how to get the colors back?



Gord Dibben MS Excel MVP