Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Cell shading with colored patterns

I'm probably overlooking something simple...

I know how to do cell shading, and I know how to do patterns. But what I'm
looking for is for the patterns to be in color.

For example, I'd like a diagonal line pattern, so that the background color
is white and the lines are blue. I can manage to get background color blue,
but the diagonal lines are black, which is not what I'm aiming for.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Cell shading with colored patterns

FormatCellsPatterns

Where you select the pattern you want, if you look below there are colors.
Selecting a color turns the pattern that color.

This applies to Excel 2003.

HTH

"Eric" wrote:

I'm probably overlooking something simple...

I know how to do cell shading, and I know how to do patterns. But what I'm
looking for is for the patterns to be in color.

For example, I'd like a diagonal line pattern, so that the background color
is white and the lines are blue. I can manage to get background color blue,
but the diagonal lines are black, which is not what I'm aiming for.

Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Cell shading with colored patterns

Format | Cells
Open the Patterns tab
Click on a colour
Click the arrow of the Patterns box and pick a pattern
done
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Eric" wrote in message
...
I'm probably overlooking something simple...

I know how to do cell shading, and I know how to do patterns. But what
I'm
looking for is for the patterns to be in color.

For example, I'd like a diagonal line pattern, so that the background
color
is white and the lines are blue. I can manage to get background color
blue,
but the diagonal lines are black, which is not what I'm aiming for.

Thanks.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"