Prev: pivot tables
Next: Pivot Table Totals
From: Don on 2 Feb 2010 15:33
I can not figure out how to select a box and change the background color
gradient to one of the standard selections? Any suggestions?
From: Gord Dibben on 2 Feb 2010 15:57
What is a "box"?

Do you mean a "cell"?

Home>Format>Format Cells>Fill>Fill Effects.

Pick a gradient.

If to be done automatically, when do you want this done and for which cell
or cells?


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 12:33:01 -0800, Don <Don(a)discussions.microsoft.com>
wrote:

>I can not figure out how to select a box and change the background color
>gradient to one of the standard selections? Any suggestions?

From: Don on 2 Feb 2010 16:38
sorry, not a cell, but a box that is linked to a macro or a button. I can
change the color of the box / button and change the effect but I do not know
how to change the color in VB - I have Excel 2007

"Gord Dibben" wrote:

> What is a "box"?
>
> Do you mean a "cell"?
>
> Home>Format>Format Cells>Fill>Fill Effects.
>
> Pick a gradient.
>
> If to be done automatically, when do you want this done and for which cell
> or cells?
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 2 Feb 2010 12:33:01 -0800, Don <Don(a)discussions.microsoft.com>
> wrote:
>
> >I can not figure out how to select a box and change the background color
> >gradient to one of the standard selections? Any suggestions?
>
> .
>
From: Don on 2 Feb 2010 17:03
I think I found the code, thanks

"Don" wrote:

> I can not figure out how to select a box and change the background color
> gradient to one of the standard selections? Any suggestions?
 | 
Pages: 1
Prev: pivot tables
Next: Pivot Table Totals