Complete Conditional Field Text For Free - Conditional Text

If you want to highlight rows in a table that contain specific text, you use conditional formatting with a formula that returns TRUE when the the text is found. The trick is to concatenate (glue together) the columns you want to search and to lock the column references so that only the rows can change.

There is no such thing as conditional formatting in Word. You will need to write your own code to achieve that.

Place your cursor where you want the conditional text to go. Go to Mailings > Rules > If...Then... Else. In the Field name list choose the field from your data source that will determine the conditional text.

Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.

How to use Microsoft Word to add conditional merge statements into templates Open Microsoft Word. Go to the Insert tab. Click Quickparts and select Field... from the dropdown. Under the Field names list, select If. Under Field Codes, enter your conditional statement.Click OK.

Click the Insert tab and then click the Quick Parts dropdown in the Text group. From the dropdown, choose Fields (Figure A). The resulting dialog lists the Word fields in the Field Names list, which you can filter using the Categories list.

Conditional fields allow you to manage sets of dependencies between fields. Such fields are available for editing and display only if the right condition is met. To create conditional fields, you must first create custom fields and then leverage such fields in forms.