checkbox question

  • Thread starter Thread starter oTTO
  • Start date Start date
O

oTTO

i have a template in excel with a checkbox. im importing from another
file, either a true or false, or 0 or 1. how do i get excel to make a
check or not based upon the values from the other file
 
Maybe you could use a helper column of cells with formulas:


=IF(A1=TRUE,CHAR(252),"")
or
=IF(A1=1,CHAR(252),"")

And format that column with a font of wingdings (it'll look like a checkmark).
 
oTTO,

You could add a checkbox, and in Format Control, link it to the cell with
the 0 (which will cause it to appear unchecked), or the 1 (checked).
Clicking the checkbox will cause it to put TRUE or FALSE into the cell, not
0 or 1.

Or you can use the following formula in a cell:
=IF(B2,"P","")

Set the font to Wingdings 2. Copy down, if you have a mess of them.
 
Back
Top