Can Check Boxes be Utilized in this Way?
 

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.

Can Check Boxes be Utilized in this Way?
 

"Eric" wrote:
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.

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Can Check Boxes be Utilized in this Way?
 

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

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
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Can Check Boxes be Utilized in this Way?
 

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?

"Max" wrote:

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

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
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Can Check Boxes be Utilized in this Way?
 

"Eric" wrote:
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?

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---