Home |
Search |
Today's Posts |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do you split a cell in half? (/)
Hi Tommy,
If you want to show a Yes/No checkbox, there is a little trick that I use. 1) Format a cell as Wingdings font 2) Add borders around the cell 3) Apply the custom format "ü";;"û" 4) Use a data validation list to limit the cell values to 1 and 0 (or just enter 1 for Yes, 0 for No). The custom format shows a tick for all positive values, nothing for negative values, and a cross for zeroes. Limiting input to 1 and 0 makes it easy to use the cell in True/False formulas. If using Excel 2007 you can make this look even better by using conditional formatting and the 3 symbol icon set. In that case just use the custom format ;; (does not show numbers in the cell), and make sure you limit the input to 0 and 1. Ed Ferrero www.edferrero.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split cell diagonally and fill half with color | Excel Worksheet Functions | |||
How do you split a cell in half? | Excel Worksheet Functions | |||
Split month in half | Excel Discussion (Misc queries) | |||
How to split (half) one cell w/o changing col or rows. | Excel Discussion (Misc queries) | |||
HOW DO I SPLIT ONE CELL IN HALF WITHIN ONE ROW? | Excel Discussion (Misc queries) |