If you have 3 optionbuttons from the forms toolbar, all linked to the same
cell, they will set that value to 1, 2 or 3 depending upon which button is
clicked.

You can test that in your CF.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sian" wrote in message
...
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