"Pick Fill Color" option not highlighted...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pdher - 25 Oct 2007 18:08 GMT

When trying to highlight cells using the "Pick Fill Color" on the
toolbar - it's not highlighted and can't be selected. Does anyone
know how to change this so I can select a full range of colors from
the color palette?

Thanks!

Reply to this Message

Bob Greenblatt - 25 Oct 2007 18:48 GMT

On 10/25/07 1:08 PM, in article
1193332091.249924.177650@t8g2000prg.googlegroups.com, "pdher"

> When trying to highlight cells using the "Pick Fill Color" on the
> toolbar - it's not highlighted and can't be selected. Does anyone
> know how to change this so I can select a full range of colors from
> the color palette?
>
> Thanks!

Unfortunately, that selection is for objects, not cell fills. If an object
is selected when you choose this tool, the choice will be active.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

pdher - 25 Oct 2007 20:30 GMT

Hi Bob and thanks for the reply. I guess I'm a bit confused as I'm
used to working on a pc. So on a mac, I cannot have a large selection
of fill colors for the cells in my spreadsheets? What qualifies as an
object?

Thanks again for your insight.

> On 10/25/07 1:08 PM, in article
> 1193332091.249924.177...@t8g2000prg.googlegroups.com, "pdher"
[quoted text clipped - 12 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Reply to this Message

Bob Greenblatt - 25 Oct 2007 20:54 GMT

On 10/25/07 3:30 PM, in article
1193340646.166444.119060@q3g2000prf.googlegroups.com, "pdher"

> Hi Bob and thanks for the reply. I guess I'm a bit confused as I'm
> used to working on a pc. So on a mac, I cannot have a large selection
> of fill colors for the cells in my spreadsheets? What qualifies as an
> object?
>
> Thanks again for your insight.

Pretty much anything that is not a cell. A line, circle, box, shape, etc.
Most anything created from the drawing tool bar. I think this is the same as
in PC Excel. They both have the same limit to maximum colors available.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

CyberTaz - 26 Oct 2007 01:39 GMT

Hi There! - I think you may have misunderstood the point Bob G. was trying
to make... It isn't that you can't fill cells with any color you want, you
just cant do it using the Pick Fill Color command (Eyedropper) in the Fill
Color button lists (Drawing, Formatting toolbars and the Borders & Shading
section of the Formatting Palette). You can, however, select any of the
colors displayed by the swatches in those lists... Just click the swatch.

The Eyedropper can only be used to fill a shape (object), not for adding
fill color to cells. To use it, select a drawn shape, choose the command,
then click on anything colored (including a filled cell) to fill the shape
with that same color. This feature isn't available in PC XL (as of 2003
anyway - not sure about '07).

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

On 10/25/07 3:30 PM, in article
1193340646.166444.119060@q3g2000prf.googlegroups.com, "pdher"

Hi Bob and thanks for the reply. I guess I'm a bit confused as I'm
used to working on a pc. So on a mac, I cannot have a large selection
of fill colors for the cells in my spreadsheets? What qualifies as an
object?

Thanks again for your insight.

On Oct 25, 1:48 pm, Bob Greenblatt <b...@nospam.com> wrote:

> On 10/25/07 1:08 PM, in article
> 1193332091.249924.177...@t8g2000prg.googlegroups.com, "pdher"
[quoted text clipped - 13 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Reply to this Message

pdher - 26 Oct 2007 16:22 GMT

But is there a way to change the default colors which are currently
available to fill the cells? The problem is that I have a large
selection of dark colors to choose from, and need lighter colors so
the black text can still be read. Can the colors that are currently
offered as a "default" selection be changed?

Thanks.

> Hi There! - I think you may have misunderstood the point Bob G. was trying
> to make... It isn't that you can't fill cells with any color you want, you
[quoted text clipped - 42 lines]
> > Bob Greenblatt [MVP], Macintosh
> > bobgreenblattATmsnDOTcom

Reply to this Message

JE McGimpsey - 26 Oct 2007 16:52 GMT

> But is there a way to change the default colors which are currently
> available to fill the cells? The problem is that I have a large
> selection of dark colors to choose from, and need lighter colors so
> the black text can still be read. Can the colors that are currently
> offered as a "default" selection be changed?

See the "Change or copy a color palette" topic in XL Help.

Reply to this Message

CyberTaz - 26 Oct 2007 17:36 GMT

... Or just open one of the Fill Color button lists, select More Colors...,
and follow your nose:-)

Alternatively go to Excel>Preferences - Color.

Signature

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

>> But is there a way to change the default colors which are currently
>> available to fill the cells? The problem is that I have a large
[quoted text clipped - 3 lines]
>
> See the "Change or copy a color palette" topic in XL Help.

Reply to this Message

pdher - 29 Oct 2007 00:34 GMT

THANKS!!

I changed it in preferences. I knew there was a way and one of you
would know!

Thanks everyone,

Pamela
On Oct 26, 12:36 pm, "CyberTaz" <typegeneraltaz1ATcomcastdotnet>
wrote:

> ... Or just open one of the Fill Color button lists, select More Colors...,
> and follow your nose:-)
[quoted text clipped - 14 lines]
>
> > See the "Change or copy a color palette" topic in XL Help.

Reply to this Message

Mac Forum / Applications / Excel / October 2007

"Pick Fill Color" option not highlighted...