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.