Check Boxes and Conditional Formatting

[Guest]

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

 

[Tom Ogilvy]

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.

 

[Bob Phillips]

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)