Can I set up a check box so that when it is checked, a specific row bg color
turns to a specific color?

Thank you for your help,
Steve

Link the checkbox to a cell in that row. If it is checked, the cell will
contain True (assuming the checkbox is in the row where you want the
behavior, link it to the cell beneath the checkbox.

Then you can use conditional formatting to operate based on the value of
that cell.

--
Regards,
Tom Ogilvy

"Steve" wrote in message
...
Can I set up a check box so that when it is checked, a specific row bg
color
turns to a specific color?

Thank you for your help,
Steve

You could use a font of Marlett, and input a value of 'a' for a check, and
then add a conditional formatting formula;a of =$A1 to each cell in the
row.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve" wrote in message
...
Can I set up a check box so that when it is checked, a specific row bg
color
turns to a specific color?

Thank you for your help,
Steve