Excel - Format Cell as True/False

Asked By Lor on 07-Apr-08 03:58 PM
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




Bob I replied on 07-Apr-08 04:24 PM
Sounds like you are remembering Access database tables.
Lor replied on 08-Apr-08 09:46 AM
Bob~

I was hoping.  Thanks.

~Lori
Colin Bradley replied to Lor on 17-Dec-10 08:03 AM
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.