Insert Conditional Field Text For Free - Insert Field Text

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.

Select the cells you want to apply conditional formatting to. Click the first cell in the range, and then drag to the last cell. Click HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains. In the Text that Contains box, on the left, enter the text you want highlighted.

On the Home tab, in the Styles group, click Conditional Formatting > New Rule. In the New Formatting Rule dialog box that opens, select the Format only cells that contain rule type, and then choose Blanks from the Format only cells with drop down: Click the Format? button.

Highlight Rows Based on a Text Criteria Click the Home tab. In the Styles group, click on Conditional Formatting. Click on 'New Rules'. In the 'New Formatting Rule' dialog box, click on 'Use a formula to determine which cells to format'.

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.

Apply conditional formatting based on text in a cell Click the first cell in the range, and then drag to the last cell. Click HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains. In the Text that Contains box, on the left, enter the text you want highlighted.

You can use the Conditional Formatting to replace text and NOT effect any formulas. Simply go to the Rule's format where you will see Number, Font, Border and Fill.