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

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 …

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 …

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

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.

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.

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 …

Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you want to remove them. Select the cells you want to check for …

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 …

This can slow down not just Excel, but the overall performance of your computer when you have an excessively formatted worksheet open. Excessive formatting can also cause printing …