Access to all Colors - Format

[robbbo]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a workbook that I have used a number of colors from filling cells, cell borders, and color of text within cells. But many colors I would like to use do not appear when I want to fill a cell with a color or change Text in a cell to a specific color. It appears the only colors I have available to me are based on Themes that I select in the Formatting Palette. When I change the theme to access color I want, colors in my workbook change to undesirable colors.

How can I get all the colors available for my workbook without limitations?

 

[CyberTaz]

I'm afraid the fact that there are limitations is inescapable

Excel is only capable of offering 40 colors as shown in the palettes for
Border Color, Font Color, etc. *Which* 40 colors can be determined in Excel>
Preferences - Color. You can also add up to 16 more for a total of 56.

Themes are a different story. Each color in a Theme's color scheme is
associate with specific elements & you can't pick one of those specific
colors for any one particular element. When you select a different Theme its
color scheme will be applied to the corresponding elements in the file
unless their color has been changed by using direct formatting [i.e., the
Paint Can, Paint Brush & Font Color tools mentioned above which offer the 40
'other' colors that aren't a part of Themes]. Further, if you customize a
Theme by selecting colors different from what its color scheme contains all
items of that type will be re-colored accordingly. You cannot, however,
determine which elements are to be associated with what colors in the Theme.

You might look into the use of Styles [Format> Styles...] for the purpose of
consistently being able to format cells in a workbook.

HTH |:>)
Bob Jones
[MVP] Office:Mac