Cell pattern/color

  • Thread starter Thread starter laughing
  • Start date Start date
L

laughing

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell formats 2
Remove Pattern Without Affecting Cell Color or Gridlines 8
Cell color and conditional formatting 2
cell pattern - color 2
Pattern colors 2
No printing of b/w designated cell patterns 1
attempting to format a color pattern in tab 3, based tab 2 and tab 5
cell format -> remove cell format pattern without effecting colors 1

Back
Top