AnsweredAssumed Answered

Help with conditional formatting

Question asked by pugmum on Dec 11, 2010
Latest reply on Dec 13, 2010 by pugmum


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 :-)