Format Cell as True/False

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

OK. It's been a while but I could've sworn that I once was able to format a
cell as a yes/no so that it appeared as a checkbox in the spreadsheet.

Is this possible or have I confused it with another application.

~Lori
 
Hi Lori,

You can format cells to display a checkbox that is either checked or unchecked but you have to format each cell individually and it doesn't matter what's in the cell. What is more likely is that you placed a checkbox control in a cell. This can be done using the Forms toolbar or the Controls toolbar.

Cheers,
Shane
 
A conditional method
=IF(C1="",$B$1,$B$2)

or use the alt character ? for TRUE and ? for a small x

I have an example I can send.

Cheers,
Colin

Swiped from my friend Mark W.
 
Back
Top