Help with conditional formatting
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?