Format Cell as True/False

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
 
S

Shane Devenshire

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
 
C

Colin Bradley

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Need Help with a VBA subroutine 0
Anything will help 0
External cell reference between two excel worksheets both in One Drive 0
Merging from an Excel file with graphics 1
VBA - exporting serial letters to single documents 0
How can the font and size of (all) citation numbers be altered? 1

Top