"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
---