Creating Boolean Columns in Excel?

[dgarris]

Does anyone know how to format a column to indicate Yes or No by displaying a Check Mark Symbol in the cell when any single character is entered?

[Ron Coderre]

Try this:

• Select the range of cells to be impacted.

Format.Cells.....Font tab
• Font: Wingdings
• Click: OK

Format.Cells.....Number tab
• Category: Custom
• Type: ü;ü;ü;ü .....Copy that from this post and paste it into the Type box.
• Click: OK

• Set the cell alignment to: Center

That should do it....anything, numeric or text, entered into a cell will display as a checkmark.

Does that help?

[dgarris]

Thanks Ron,

It works as you stated.

Is there any way to have it change to a check mark for all characters except the space bar, in which case insert a space into the cell?