PC Review


Reply
Thread Tools Rate Thread

Cell pattern/color

 
 
laughing
Guest
Posts: n/a
 
      3rd Dec 2007
How can I apply a custom pattern to cells, rather than the standard patterns
available in Excel 2003?
 
Reply With Quote
 
 
 
 
MartinW
Guest
Posts: n/a
 
      3rd Dec 2007
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?



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      3rd Dec 2007
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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/PATTERN CELL extremejobtvshow@gmail.com Microsoft Excel Programming 5 28th Jun 2008 07:49 PM
cell pattern - color =?Utf-8?B?dGlrY2h5ZV9vbGRMZWFybmVyNTc=?= Microsoft Excel Misc 2 11th Apr 2007 12:28 PM
Date sensitive cell pattern color Darrell Shuman Microsoft Excel Worksheet Functions 4 17th Aug 2006 04:26 PM
Formatting cell pattern color =?Utf-8?B?QWxleA==?= Microsoft Excel Misc 2 4th Nov 2004 04:15 AM
can't see color pattern in cell =?Utf-8?B?SlBARE9MRQ==?= Microsoft Excel Worksheet Functions 1 9th Sep 2004 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:52 AM.