Shade a row on click

A

ACM

I'm sharing a workbook with many users that lists projects we ar
working on. When a project is complete there is a check box that w
click to indicate it is complete.
How can I get the row to be shaded when the box is checked, so that w
can see at a glance what is complet and what is not?
Thanks
 
F

Frank Kabel

Hi
try using Format - Conditional Format' for this and use the linked cell
of your checkbox as value
 
P

Peo Sjoblom

What kind of check box are you using? You can use conditional formatting
Assume you are using the check box from the forms toolbar, if you right
click the check box
and select format control you can set a cell link, use a cell that is on
the same row, in this example row 8
choose a cell that is out of view, for example IV8. Select row 8 and do
format>conditional formatting,
formula is

=$IV$8

click format and select patterns and click OK twice

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top