I have trouble finding enough FILL colours for all my staff scheduling needs.
I can modify the colours already there but I need to use them as well. Is
there any Add-in or way I can download to increase the number of FILLs? Or is
there anyway I can get the option of 'More Colors', 'Custom Colors'?

Roachie,
If you can't increase the number of colours, would using patterns in
conjunction with colours give you enough variation ?

NickHK

"Roachie" wrote in message
...
I have trouble finding enough FILL colours for all my staff scheduling
needs.
I can modify the colours already there but I need to use them as well. Is
there any Add-in or way I can download to increase the number of FILLs? Or
is
there anyway I can get the option of 'More Colors', 'Custom Colors'?

Can one really distinguish at a glance among all of these colors??

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Roachie wrote:
I have trouble finding enough FILL colours for all my staff scheduling needs.
I can modify the colours already there but I need to use them as well. Is
there any Add-in or way I can download to increase the number of FILLs? Or is
there anyway I can get the option of 'More Colors', 'Custom Colors'?

"Jon Peltier" wrote:
Can one really distinguish at a glance among all of these colors??

- Jon

Jon, it depends ...

Of course the eye (non colour impaired) can easily distinguish between many
thousands of unique colours. But in context of what I assume the OP
requires - possibly. Very much depends on the choice of colours, how they
are intended to be used in relation to one another, and to what extent
"shift" in colour is intended to convey an overall impression vs
highlighting something specific.

I regularly work with significantly more than 56 colours, all displayable in
Excel.

Regards,
Peter

Try something like:

Activecell.Interior.Color=RGB(Red_no,Green_no,Blue _no)

"Peter T" wrote:


"Jon Peltier" wrote:
Can one really distinguish at a glance among all of these colors??

- Jon

Jon, it depends ...

Of course the eye (non colour impaired) can easily distinguish between many
thousands of unique colours. But in context of what I assume the OP
requires - possibly. Very much depends on the choice of colours, how they
are intended to be used in relation to one another, and to what extent
"shift" in colour is intended to convey an overall impression vs
highlighting something specific.

I regularly work with significantly more than 56 colours, all displayable in
Excel.

Regards,
Peter

"Jared" wrote in message:

Try something like:

Activecell.Interior.Color=RGB(Red_no,Green_no,Blue _no)


With this Excel will match the defined colour to the nearest colour that
exists in the palette and apply its associated colorindex as the cell
format. Eventual formatted colour may or may not be was believed to have
been defined. Unless trying to apply one of the standard or "pure" colours
the odds are 56 / 16777216 against !

Regards,
Peter