Shading cells by using Checkbox control in Excel

[Scanner]

I'm hoping this will be simple for some Excel Guru out there.

I have an Excel file that is basically a series of "checkoff" sheets for items to be done on a rather extensive project.

I know...I should be using MSProject or some other tool, but the Gods on Mt. Olympus have declared that I not be privy to anything other than Excel at this point.

Along with the typical description of the step, I've added a checkbox control to the first column to make things a little more user-friendly.

Here's my issue...If the checkbox value is "True" I would like to have the remainder of that line shaded to show it as completed. I don't want the text affected in any way, only the shading.

Can anyone help?

Thanks,

Scanner

 

[SkipVought]

Hi,

Link each checkbox to a cell in an unused column, let's say column Z.

Then, using Format/ConditionalFormatting, you can shade rows with up to 3 different shades.

1) Select the ENTIRE AREA that you want ot apply this shading to.

2) Format/Conditional Formatting

3) Select Formula is: and then enter this formula...
[tt]
=
[/tt]
...and select the cell in column Z from the corresponding ROW that your ENTIRE AREA begins with.

4) Hit F4 to toggle the cell reference to maintain an absolute column reference and relative row reference so it will look like this when you're done...
[tt]
=$Z5
[/tt]
if your ENTIRE AREA begins with row 5. THEN finsh the formula with TRUE
[tt]
=$Z5=TRUE
[/tt]

5) then select the FORMATTING that you want for the checked rows.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}