Shading cells

Chartman of the Bored · Apr 26th, 2002, 10:21 PM

Is it possible to shade cells, rows, or columns so that the color fades from solid to white?

Damon Ostrander · Apr 26th, 2002, 10:55 PM

Hi Chartman,

Unfortunately, no. Gradient fills only apply to Shape objects, not cells.

Ivan F Moala · Apr 26th, 2002, 11:11 PM

You can if you use the bacground Option
Fornmat > Sheet > background.

You will have to play around with Shapes
sizes and colour gradients to get the right result.....

eg Select a shape > rectangle
colour it with suitable graient using
your 2 colours.
Copy and paste into a Graphics program
save it then Load it in via above method.

HTH

Chartman of the Bored · Apr 27th, 2002, 01:42 AM

Thanks. I'll try using the background method. It's a shame, though, that Excel doesn't have such a feature built-in.

Apr 26th, 2002, 10:55 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Chartman, Unfortunately, no. Gradient fills only apply to Shape objects, not cells. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Apr 26th, 2002, 11:11 PM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	You can if you use the bacground Option Fornmat > Sheet > background. You will have to play around with Shapes sizes and colour gradients to get the right result..... eg Select a shape > rectangle colour it with suitable graient using your 2 colours. Copy and paste into a Graphics program save it then Load it in via above method. HTH __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 10:21 PM	#1
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	Is it possible to shade cells, rows, or columns so that the color fades from solid to white?

Apr 27th, 2002, 01:42 AM	#4
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	Thanks. I'll try using the background method. It's a shame, though, that Excel doesn't have such a feature built-in.