View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?