6 Replies Latest reply on Dec 13, 2010 11:04 AM by pugmum

    Help with conditional formatting



      Help with conditional formatting


      Hi Everyone,

      I have a field called "phone number". I have another field called "Wish to be called?" which has a checkbox that I can either enter "yes" or "no" into.

      What I want to happen is that the field for "phone number" turns red if "wish to be called" is checked "yes". I'm pretty sure I can do this with a formula in conditional formatting but am not sure exactly how. Conditional formatting is simple when it is isolated to the particular field that it is assigned to but when the variable is another field it gets a bit too tricky for me. Can someone out there help me?

      Thanks :-)