On the form template, select the control that you want to add conditional formatting to, and then click Conditional Formatting on the Format menu. In the Conditional Formatting dialog box, click Add.

How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.

In Excel, from the Home tab, click Conditional Formatting > New Rule. Next, select the “ Use a formula to determine which cells to format ” option, enter your formula and apply the format of your choice.

On the Home tab, click Conditional Formatting, and then click New Rule. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.

You can use conditional formatting to highlight cells that contain values that meet a certain condition, or format a whole cell range and vary the exact format as the value of each cell varies.

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional …

One way to apply shading to alternate rows or columns in your worksheet is by creating a conditional formatting rule. This rule uses a formula to determine whether a row is even or odd numbered and …

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. Point to Icon Sets, and then click the icon set that …

Follow these steps to create a custom formatting rule—which will only be available in the worksheet in which you create it. In a worksheet, select the range of cells in which you’ll be entering negative …

Use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who has received …