Excel Background Shading

[Guest]

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!

 

[Gord Dibben]

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

 

[David McRitchie]

You can have black as a pattern within the cell
Format, Cells, pattern, choose a pattern, and choose a color.

 

[Gord Dibben]

David

Can you expand on this a bit or have I misread?


Gord

 

[Guest]

Hi,

You can have different border, Fill Pattern and Font color at one time.

Challa Prabhu

 

[David McRitchie]

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]

Thanks David.

Gord

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).

David

Can you expand on this a bit or have I misread?


Gord