Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    NC, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    using if statements to strike through text (excel 2000)

    Post deleted by larsonjj1

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: using if statements to strike through text (excel 2000)

    I think that you want to use the Format | Conditional Formatting instead of an IF function. Check it on in help and then post back if you still have questions. It's a little tricky. HTH --Sam

    PS there's no attachment
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: using if statements to strike through text (excel 2000)

    Having the presented item show as struck-through is fine, but for analytical purposes I'd also keep another code showing that the item has been presented. My dear wife drove me nuts writing custom functions on a spreadsheet analysing terminated employees; the termination was denoted only by striking the employee name through.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Location
    NC, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using if statements to strike through text (excel 2000)

    Post deleted by larsonjj1

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using if statements to strike through text (excel 2000)

    I think you need to change your conditional formula to:

    <pre>=$H5=TRUE
    </pre>

    Legare Coleman

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: using if statements to strike through text (excel 2000)

    1) Delete the first two rows, so that Excel does not get confused by the merged cells. If you leave the merged cell, then the relative formula below will not work correctly.
    2) Insert a row and redo the header without the merged cells.
    3) Remove the regular strikethrough format
    4) Select column A
    5) Format | Condition Formatting
    6) Set the drop-down to "Formula Is"
    7) In the formula box type:
    <pre> =H1</pre>

    8) Press the format button & check Strikethrough
    I made the formula relative in step 7 so that when you add new checkboxes, everything will work correctly. New spreadsheet is attached. HTH --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: using if statements to strike through text (excel 2000)

    What problem did you have with the merged cells? I put my formula in with the merged cells there, and it worked fine.

    If you are going to use this formula across several columns (as his sheet does), then you need to make the column absolute, ie: $H1
    Legare Coleman

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: using if statements to strike through text (excel 2000)

    Your formula works fine, and because you entered it row relative, it can be copied to other cells in the row. I thought it would be easier to enter the conditional formula for the entire column as =H1, but the merged cells messed me up. I thought it was simpler to remove the merged cells, than to have him select A5:A65536 and enter =H5 for the formula.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •