Check a Check Box if

I

IntricateFool

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?
 
R

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
 
R

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.
 
B

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
 
Top