Excel Background Shading

S

SmokeyMo

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!
 
G

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
 
D

David McRitchie

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

challa prabhu

Hi,

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

Challa Prabhu
 
D

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

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


Gord Dibben said:
David

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


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top