Excel Background Shading
Can anyone help me. I am trying to shade one excel cell 2 different colors.
Is there a way I can do this? I am talking about the background not the font color. Thanks! |
Excel Background Shading
Cells can have only one background color.
You could workaround by placing a drawing objec(rectangle?)t over half the cell. Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 18:16:01 -0700, SmokeyMo wrote: Can anyone help me. I am trying to shade one excel cell 2 different colors. Is there a way I can do this? I am talking about the background not the font color. Thanks! |
Excel Background Shading
You can have black as a pattern within the cell
Format, Cells, pattern, choose a pattern, and choose a color. -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Cells can have only one background color. You could workaround by placing a drawing objec(rectangle?)t over half the cell. Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 18:16:01 -0700, SmokeyMo wrote: Can anyone help me. I am trying to shade one excel cell 2 different colors. Is there a way I can do this? I am talking about the background not the font color. Thanks! |
Excel Background Shading
David
Can you expand on this a bit or have I misread? Gord On Tue, 24 Jul 2007 23:01:36 -0400, "David McRitchie" wrote: You can have black as a pattern within the cell Format, Cells, pattern, choose a pattern, and choose a color. |
Excel Background Shading
Hi,
You can have different border, Fill Pattern and Font color at one time. Challa Prabhu "SmokeyMo" wrote: Can anyone help me. I am trying to shade one excel cell 2 different colors. Is there a way I can do this? I am talking about the background not the font color. Thanks! |
Excel Background Shading
You've not misread anything. Stippling, crosshatching, etc
gives you a means of distinguishing cells ([Fill] Pattern dropdown) particularly in black and white printing, which is on the pattern tab within format, and background color is also on the pattern tab. The poster did not define what was meant by two colors, if he means gradient shading from dark blue to light blue like the title bar than he would have to use a transparent shape (picture). "Gord Dibben" <gorddibbATshawDOTca wrote in message ... David Can you expand on this a bit or have I misread? Gord On Tue, 24 Jul 2007 23:01:36 -0400, "David McRitchie" wrote: You can have black as a pattern within the cell Format, Cells, pattern, choose a pattern, and choose a color. |
Excel Background Shading
Thanks David.
Gord On Wed, 25 Jul 2007 07:02:03 -0400, "David McRitchie" wrote: You've not misread anything. Stippling, crosshatching, etc gives you a means of distinguishing cells ([Fill] Pattern dropdown) particularly in black and white printing, which is on the pattern tab within format, and background color is also on the pattern tab. The poster did not define what was meant by two colors, if he means gradient shading from dark blue to light blue like the title bar than he would have to use a transparent shape (picture). "Gord Dibben" <gorddibbATshawDOTca wrote in message ... David Can you expand on this a bit or have I misread? Gord On Tue, 24 Jul 2007 23:01:36 -0400, "David McRitchie" wrote: You can have black as a pattern within the cell Format, Cells, pattern, choose a pattern, and choose a color. |
All times are GMT +1. The time now is 06:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com