To add a conditional format, click New Rule. The New Formatting Rule dialog box appears. To add a new conditional format based on one that is already listed, select the rule, then click Duplicate Rule. The duplicate rule is copied and appears in the dialog box. Select the duplicate, then select Edit Rule. The Edit Formatting Rule dialog box ...

You can use conditional formatting to highlight cells that contain values which meet a certain condition. Or you can 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 formulas.

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 Data Bars, and then click a gradient fill or a solid fill.

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.

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 then applies the shading accordingly.

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 birthday greetings from you.

Use conditional formatting to apply banded rows or columns. You can also use a conditional formatting rule to apply different formatting to specific rows or columns. Here's how: On the worksheet, do one of the following: To apply the shading to a specific range of cells, select the cells you want to format.

If the specified conditions are true when a user fills out a form that is based on your form template, the conditional formatting is displayed. You can use conditional formatting to apply bold, underline, italic, strikethrough, font color, and background color to controls.

What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that uses formulas for text that contains rules, and then apply conditional formatting that is supported in earlier versions of Excel.