Check a Check Box if

[Guest]

How would I go about making a check box marked checked based on other cells.

If I have three columns that all equal "Yes", I would like the respective
checkbox to contain a check mark.

Any suggestions?

 

[Raffael]

Every check box is linked to a cell, which value may be 0 or 1 (1 being the
number for "check").

You may change the "linked cell" at the check box properties window (right
mouse button > format control... > "control" tab), or you may select the
check box and edit the formula bar with "=A1", changing "A1" with a cell of
your choice.

Now it's with you!

regards

 

[Raffael]

Every check box is linked to a cell, which value may be 0 or 1 (1 being

the number for "check").

Ops, sorry. I mean TRUE (checked) or FALSE.

 

[Raffael]

Just remembered: if you manually check the Check Box, you'll lose the
formula you may have put in the "linked cell".


So, if you don't intend to click on the Check Boxes, it'll work. Otherwise,
you'll have to use some macros.

 

[Biff]

Here's one way without using checkboxes:

Assume you want cell A1 to display a checkmark if cells C1:E1 = YES

Format cell A1 to font Marlett

Enter this formula in A1:

=IF(COUNTIF(C1:E1,"yes")=3,"a","")

The "a" MUST be lowercase.

Or, to eliminate any confusion:

=IF(COUNTIF(C1:E1,"yes")=3,CHAR(97),"")

Biff