the number of cell shade colors reduced

[Guest]

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]

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 Tools>Options>Color and "Copy colors from".

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

Save the "bad" workbook.


Gord Dibben MS Excel MVP

 

[Guest]

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]

David

Good stuff.

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


Gord

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 MS Excel MVP