Conditional format formula for another field with check boxes
I have a field that contains a checkbox value set and multiple boxes will be checked for that field for one record. Field A.
I would like to format Field B to "Grey Out" IF Field A has the "continue" value checked off. The = function doesn't work when multiple values are checked off in Field A.
I also have another Field C (an edit box) which will contain a text phrase, I would like to have the same function (have the fill grey out) in Field D If the phrase in Field C contains the word "discontinue".
these fileds are all of the same table if that makes any difference.