checkbox for condtn'l formatting mod(row(),2)

[Guest]

I've used the mod(row(),2) conditional formatting on a spreadsheet and need
to create a checkbox so iusers can turn it on and/or off.

What would the formula be in the conditional formatting dialog box to make
this happen???

Many thanks, as always,

Marika

 

[Biff]

Hi!

Link the checkbox to a cell and then include a reference
to that cell in your conditional formatting formula.

Assume you link the checkkbox to cell B1. When "checked"
cell B1 will return the value TRUE. When "unchecked" B1
will return the value FALSE.

You can hide the TRUE or FALSE by setting the text color
to be the same as the fill color. When someone checks or
unchecks the checkbox, it will turn on or off the
conditional formatting.

Use something like this for the cf formula:

=AND(B1=TRUE,Your_CF_formula_Here)

Biff