You can apply conditional formatting to a range of cells (either a selection or a named range), an Excel table, and in Excel for Windows, even a PivotTable report.

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 …

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 …

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 …

Select Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. In the box next to values with, pick the formatting you want to apply to the duplicate values, and then select OK.

Click any cell. If you want to find only cells with a specific conditional format, start by clicking a cell that has that format. On the Edit menu, click Find, and then click Go To. Click Special, and …

Issues that cause a minor loss of fidelity might or might not have to be resolved before you continue saving the workbook—data or functionality is not lost, but the workbook might not …

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 …

To edit the conditional formatting rule, click one of the cells that has the rule applied, go to Home > Conditional Formatting > Manage Rules > Edit Rule, and then make your changes.