Conditional formatting can also be used to make each text box in the section read-only if a check box is cleared.
Along with its other uses, with conditional formatting you can automatically make one or more controls read-only. This allows a control to be read, but not changed, after a particular condition is met — for example, after a check box is selected. In the case of text boxes, the control won't look any different, but the person filling out the form will not be able to type in it.
To illustrate the need for this, let's say you show different views of a form to different people based on their role in your business. For example, in an expense report form, you create one view for people filling out expenses and a second view for people who ultimately approve those expenses. You can use conditional formatting to disable expense text boxes in the second view to make sure that approvers don't accidentally change submitted expenses.
Note You can also disable buttons and other controls based on conditions in the form. When a control is disabled, it appears dimmed in the form. For example, you can disable a Proceed to Next Screen button if users haven't yet accepted the terms and conditions you've specified for your form.