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

"IntricateFool" wrote in message
...
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?