8 Replies Latest reply on Dec 7, 2012 5:39 PM by EricaJackson

    Conditional format formula for another field with check boxes

    EricaJackson

      Title

      Conditional format formula for another field with check boxes

      Post

           Hi Developers!

           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.

           Thanks

           Erica