Can Check Boxes be Utilized in this Way?

E

Eric

I was wondering if it was possible to add a check box at the end of a row and
when that box is checked, all data in the cells to right of it is crossed
out. I am not sure if that is possible since the only things i can find are
formatting for the cell the check box is in not adjacent cells to which it
can be applied.
 
M

Max

Eric said:
I was wondering if it was possible to add a check box at the end of a row and
when that box is checked, all data in the cells to right of it is crossed
out. I am not sure if that is possible since the only things i can find are
formatting for the cell the check box is in not adjacent cells to which it
can be applied.
Click to expand...

Tinker with this ..

Assume data in A2:D2

Add a forms check box over say F2
Right-click > Format Control & point the cell link to: E2

Select A2:D2 (A2 active),
Click Format > Conditional Formatting
Under condition 1, make the settings:
Formula is: =$E2
Click Format > Font tab > Check "Strikethrough" > OK
Click OK at the main dialog

Test it out .. When the check box is checked, E2 will evaluate to TRUE,
and strikethrough will be applied on the contents in A2:D2

Col E could be hidden away,
or formatted in white font to mask, and the check box placed over E2
 
M

Max

Some clarifications
.. when box is checked, all data in the cells to right of it is crossed out
Click to expand...

In my example I had presumed data was to the left of the check box,
since you said:
.. add a check box at the end of a row
Click to expand...
Took "end of a row" to mean "to the right of data in the row" <g>

Either way, just use the same cond format formula ( =$E2 )
when you select the cells to set up the CF
 
E

Eric

I have been messing around with that but came into a problem. How do you make
sure each check box is in a given cell rather than too large for that single
cell?
 
M

Max

Eric said:
I have been messing around with that but came into a problem.
How do you make sure each check box is in a given cell
rather than too large for that single cell?
Click to expand...

Check boxes just "float" over the underlying cells (they don't go into the
cells). But we can try to fit it to cells' grid via holding down Alt key
while drawing/moving/resizing the check box to fit to cell/cells grid.
Enlarge the cell/s sizes to suit (row height/col width), then resize to fit
to grid.
 
Top