Getting only one of two check boxes marked

[KATHARXIX]

Hi,

Im triyng to set a calc sheet in libre office calc with two check box and I use check boxes for the user to mark 'yes' or 'no'. The problem is that eventually one can check the two check boxes, which make no sense "[x] Yes [x] No". I would like that only one of both can be checked. For example, if the 'Yes' is checked the "No" check box must be unmarked and if checks the 'No', the 'Yes' should be unchecked.

Remember is a checkbox no a button. Thanks

[RoryOF]

Use one checkbox and set No when unchecked. Or use Radio buttons.