Conditional Formatting

[D]

I would like to add conditional formatting to a section, so that when a
certain check box is checked (not blank) the section becomes shaded. It is
not working. What is happening is that the form is just opening with the
section shaded, no matter what you do to the check box. I can get this
conditional formatting to work if I link it to a text box and not a check
box......but I would like to use the check box.

Thank you in advance for your help.

 

[S.Y.M. Wong-A-Ton]

The value of a checkbox is either "TRUE" or "FALSE". So when setting up
conditional formatting on the section, instead of using "is not blank" in the
second dropdown list box on the Conditional Format dialog box, use "is equal
to" in the second dropdown list box and select "TRUE" in the third dropdown
list box.

 

[D]

Thank you.

The value of a checkbox is either "TRUE" or "FALSE". So when setting up
conditional formatting on the section, instead of using "is not blank" in the
second dropdown list box on the Conditional Format dialog box, use "is equal
to" in the second dropdown list box and select "TRUE" in the third dropdown
list box.