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