Need a button to click to toggle cell color on/off
 

I know how to toggle say..the grid....on or off, using a button. But,
how do I toggle cell interior color on/off. Specifically, I want to
click on a button and make a "No Fill" cell yellow, or a yellow cell
"No Fill". I am using Excel 2002.

As usual, thanks for any and all help.

Tonso

Need a button to click to toggle cell color on/off
 

The formatting toolbar has a color picker button.

Takes two clicks, not one, but not too onerous in my mind.

If the only two choices are yellow and no color, record a macro while toggling
on/off using the default color picker.

Assign the macro to a button.

Just rmember to change the hard-coded cell reference to ActiveCell


Gord Dibben MS Excel MVP

On 6 Feb 2007 14:39:35 -0800, "Tonso" wrote:

I know how to toggle say..the grid....on or off, using a button. But,
how do I toggle cell interior color on/off. Specifically, I want to
click on a button and make a "No Fill" cell yellow, or a yellow cell
"No Fill". I am using Excel 2002.

As usual, thanks for any and all help.

Tonso

Need a button to click to toggle cell color on/off
 

On Feb 6, 7:56 pm, Gord Dibben <gorddibbATshawDOTca wrote:
The formatting toolbar has a color picker button.

Takes two clicks, not one, but not too onerous in my mind.

If the only two choices are yellow and no color, record a macro while toggling
on/off using the default color picker.

Assign the macro to a button.

Just rmember to change the hard-coded cell reference to ActiveCell

Gord Dibben MS Excel MVP

On 6 Feb 2007 14:39:35 -0800, "Tonso" wrote:



I know how to toggle say..the grid....on or off, using a button. But,
how do I toggle cell interior color on/off. Specifically, I want to
click on a button and make a "No Fill" cell yellow, or a yellow cell
"No Fill". I am using Excel 2002.

As usual, thanks for any and all help.

Tonso- Hide quoted text -

- Show quoted text -

Thanks once again for helping me sove a problem and learn a bit more
about Excel VBA!
Tonso