Re: Checkbox checked on value of cell I would dump the check boxes and use simulated checkboxes In your row, format it as Marlette Use a Formula in each cell =IF(F10="xxx","a","") =IF(F10="yyy","a","") 'etc The a's will show up as a CheckMark You can also
automate this with a Change Event and run other codes or formulas from ...