All,
I have a Pass/Fail column, B.
In B2 I have three radio buttons, Pend, Pass, Fail.
My need is to
1. Have multiple rows in column B with the same radio buttons. There may be skips. So for example, B2-B10 will have the radio buttons. B11 will not have the radio buttons. B12-B20 will have the radio buttons.
2. Conditional formatting. Pending = no cell fill color, Pass = cell fill green, and Fail = cell fill red.
I have added three individual radio buttons to B2 and linked to Q2.
Select Pend Q2 = 1
Select Pass Q2 = 2
Select Fail Q2 = 3
So far so good.
However, all additional cells with radio buttons set Q2 to a unique value and only one radio button in the the entire B column can be set at a time. Each cell needs to have one of the radio button set. And, initially the Pending radio button needs to be set for each cell.
Various attempts at using an index have failed, so clearly my approach is hosed.
I would be very grateful if you could point me in the right direction.
Many thanks!!
I have a Pass/Fail column, B.
In B2 I have three radio buttons, Pend, Pass, Fail.
My need is to
1. Have multiple rows in column B with the same radio buttons. There may be skips. So for example, B2-B10 will have the radio buttons. B11 will not have the radio buttons. B12-B20 will have the radio buttons.
2. Conditional formatting. Pending = no cell fill color, Pass = cell fill green, and Fail = cell fill red.
I have added three individual radio buttons to B2 and linked to Q2.
Select Pend Q2 = 1
Select Pass Q2 = 2
Select Fail Q2 = 3
So far so good.
However, all additional cells with radio buttons set Q2 to a unique value and only one radio button in the the entire B column can be set at a time. Each cell needs to have one of the radio button set. And, initially the Pending radio button needs to be set for each cell.
Various attempts at using an index have failed, so clearly my approach is hosed.
I would be very grateful if you could point me in the right direction.
Many thanks!!