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!

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!

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!

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.

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!

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.

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.