Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    How does this work (Excel 2002/3)

    Hi

    Attached is workbook created by Ozgrid Business Apps.

    Can anybody please tell me how it works please?

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How does this work (Excel 2002/3)

    It is based on cond formatting.

    In Toggle visibility if Cell c1 is true the formatting of the text is white (=$C$1)

    In Toggle highlighting it sets the cond format based on the numbers in B1 and D1 and the cond in E1 [=AND($A2>=FirstNum,$A2<=SecondNum,CheckBoxLink)]

    There does no appear to be anything in the 3rd sheet.

    Steve

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: How does this work (Excel 2002/3)

    He Steve

    I suppose the name of the workbook should have been a clue, sometimes I can't see the woods for the trees. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Thanks for your response.

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: How does this work (Excel 2002/3)

    Hi Steve,

    OK, maybe it's early and the brain ain't working yet.

    How does checking/unchecking the checkboxes change a cell from true to false or vice versa? In "Toggle Visibility" worksheet, there is a true/false in C1. I see no conditional formatting for it, no formulas, etc. Similarly in the "Toggle Highlighting" sheet.

    I see from the format control info for the checkboxes that these cells seem to be linked to the checkbox. So does that mean that C1 just reflects the state of the checkbox?

    Is there anything else special about these checkboxes?

    Is this something relatively new in Excel? I don't recall this feature (but then again, I thought Paste Special | Comment was pretty new too).

    Thanks.

    Fred

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How does this work (Excel 2002/3)

    As you note, the Cell Link box in Format | Control contains $C$1. This means that clicking the check box will change the value of C1, and changing the value of C1 will tick or clear the check box. It's a two-way link.

    The check box has been created from the Forms toolbar. This has been around for several versions - at least since Excel 97, possibly earlier.

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: How does this work (Excel 2002/3)

    Thanks Hans.

    I haven't really explored the Forms toolbar very much. Something to add to the list.

    Fred

Posting Permissions

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