| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes
I have a form with a check box in each of 7 columns, I have added an 8th
column to count how many boxes in each row are checked but now I need to get rid of the "true" & "false" underneath my check boxes in each cell when the box is checked or un-checked. My formula looks like this: =countif(e3:o3,true) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
Irishsuly
Color the font white. Mike Rogers "Irishsuly" wrote: I have a form with a check box in each of 7 columns, I have added an 8th column to count how many boxes in each row are checked but now I need to get rid of the "true" & "false" underneath my check boxes in each cell when the box is checked or un-checked. My formula looks like this: =countif(e3:o3,true) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
I knew it was probably something simple.... Thanks.
"Mike Rogers" wrote: Irishsuly Color the font white. Mike Rogers "Irishsuly" wrote: I have a form with a check box in each of 7 columns, I have added an 8th column to count how many boxes in each row are checked but now I need to get rid of the "true" & "false" underneath my check boxes in each cell when the box is checked or un-checked. My formula looks like this: =countif(e3:o3,true) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Boxes | Excel Discussion (Misc queries) | |||
| Tracking Check Boxes | Excel Worksheet Functions | |||
| Linked Check Boxes | Excel Discussion (Misc queries) | |||
| Selecting Check Boxes | Excel Discussion (Misc queries) | |||
| How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
Linear Mode
