Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) |