Hi,
I would like to perform a conditional formatting in a form and would like your help.
I currently have a form where users enter in data. To aid them in identifying the fields they would complete, I am interested in using a conditional formatting.
For instance, if a user would select "Yes" on field A, then the field B's back color would change to white, thus the user completes field B. If the user selects "No" on field A, then the field B's back color would remain gray. Moreover, the user would not complete field B.
Hope this makes sense.
I tried writing the following and received an error message:
Condition 1:
Expression is =IIf([Application Form Sent?]="Yes",TRUE,FALSE)
The error message included:
"The expression you entered contains invalid syntax."
Could you suggest an expression that I use in this instance? Or do you recommend an alternative way to conditional formatting, such as "Field has focus"?
I appreciate your help.
mdr0906
I would like to perform a conditional formatting in a form and would like your help.
I currently have a form where users enter in data. To aid them in identifying the fields they would complete, I am interested in using a conditional formatting.
For instance, if a user would select "Yes" on field A, then the field B's back color would change to white, thus the user completes field B. If the user selects "No" on field A, then the field B's back color would remain gray. Moreover, the user would not complete field B.
Hope this makes sense.
I tried writing the following and received an error message:
Condition 1:
Expression is =IIf([Application Form Sent?]="Yes",TRUE,FALSE)
The error message included:
"The expression you entered contains invalid syntax."
Could you suggest an expression that I use in this instance? Or do you recommend an alternative way to conditional formatting, such as "Field has focus"?
I appreciate your help.
mdr0906