Excel: check box that Strikethrough a row

[PS1983]

Hi there!
Can u help me with this one?

I createt a checkbox in my excel sheet "o"

o | Text blabla | Text blabla | .... | .......

now when the box gets checked, i want the text to be strikedthrough.

I can't reccord a macro that is able to do this easy operation!

can somebody help me

thanks in advance

greets
Steve

 

[Bowers74]

Insert a new column A. Right-click on the checkbox and enter the format window. Select cell "A2" as the linked cell.

Mark all of the cells in the ROW containing the text you want to strikeout and Click the menu Format -> Conditional formatting. Select "Formula is" from the drop-down for the first condition and then enter (without quotes) "=$A2=TRUE".
Then select the Strikethrough format option in the format window.

Now, when you check the checkbox, each cell you marked will be striked-out.

Unfortunately, you will have to go through this for each line and each checkbox. It would be a lot easier if you were allowed to record macros.

Good Luck,
Bowers 74

If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!