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

[Tonso]

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

 

[Gord Dibben]

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

 

[Tonso]

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





- Show quoted text -

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