How can I apply a custom pattern to cells, rather than the standard patterns
available in Excel 2003?

Hi laughing,

Excel is not as friendly as other programs in this regard,
however, it is not too painful.

Go to Tools>Options>Color Tab
Click on a color swatch and click the Modify button
then you can adjust the color for that swatch.

Then when the function you are using calls up the
color pallette your custom color will be available.

HTH
Martin


"laughing" <(E-Mail Removed)> wrote in message
news:8B277D27-2759-4D00-B47C-(E-Mail Removed)...
> How can I apply a custom pattern to cells, rather than the standard
> patterns
> available in Excel 2003?

Do you mean "color"?

Tools>Options>Color>Modify will allow you change a color to any rgb value you'd
like.

Or run a macro with your parameters.

Sub foo()
ActiveCell.Interior.Color = RGB(170, 112, 230)
End Sub

If you mean "pattern" like diagonal stripes or cross-hatch, I don't know if you
can.


Gord Dibben MS Excel MVP

On Mon, 3 Dec 2007 05:07:00 -0800, laughing <(E-Mail Removed)>
wrote:

>How can I apply a custom pattern to cells, rather than the standard patterns
>available in Excel 2003?