I have optionbuttons 'Pass' and 'Fail'. Using conditional formatting one
turns the adjacent cell green and the other red (ie condition is 'if the
optionbutton-linked cell contains TRUE turn green, if FALSE turn red')
Users being users, someone will click an optionbutton by mistake before the
test has been run. I want to add a third optionbutton 'Not Tested' which
will reset the adjacent cell colour.
So I either need a way to return, say, a number from my optionbuttons rather
than TRUE/FALSE or some other way round it. Is the key the TripleState
property? Does anyone have any ideas?
The worksheet can potentially contain results for hundreds of tests so I
REALLY don't want to start writing code. It's big enough as it is.
Ideas greatly appreciated! Sian