Excel - Check Box Functions
If you have a linked cell assigned to the check box then you can use
conditional formatting to do this.
Assume the linked cell is A1 and the cell to strikethrough is B1
Select cell B1
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1
Click the Format button
Select the Font tab
Select Strikethrough
OK out
--
Biff
Microsoft Excel MVP
"Mags" wrote in message
...
Is it possible to add a function to a check box so that when it's checked,
the words in an associated cell will automatically strike through?
|