Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Queensland, Australia
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting up an option button (2003)

    Hi
    I have a spreadsheet that has a list in it, I need to send out this list to a number of people for them to advise what items on the list they require or don't. I recently saw a similar list and in it I was able to tick an option button which then highlighted the particular row in a certain colour to indicate that item was required there was also a second option button which when selected highlighted the row in a different colour to indicate the item was not required.

    I don't use Excel a lot so was hoping someone could help me out with this.

    Thanks in advance
    Dax


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

    Re: Setting up an option button (2003)

    It could be done using option buttons or check boxes, but it would be a lot of work to set up and to maintain, and it would require using VBA code, so if users have macro security set to high, it would be a problem.

    I have attached a sample workbook using a simpler approach: cells in C2:C6 use Data | Validation to show a dropdown list. The list is the named range Status on Sheet2. I've left Sheet2 visible so that you can see the range, but you'll probably want to hide this sheet. The user can select 'Required' or 'Not Required' from the dropdown list, or leave the cell blank.
    Format | Conditional Formatting is used to highlight cells in a row according to the value selected in thre dropdown list in column C.
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Queensland, Australia
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting up an option button (2003)

    Hi Hans
    Thank you very much that's exactly what I was after, I've applied your suggestion to my spreadsheet and it works perfectly.

    Thanks again you have been a great help
    Cheers
    Dax


Posting Permissions

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