Setting up an option button (2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote