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

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.

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 Highlight Cells Rules, and then click Text that …

Conditional formatting quickly highlights important information in a spreadsheet. But sometimes the built-in formatting rules don’t go quite far enough. Adding your own formula to a conditional formatting rule …

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.

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 …

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 duplicates. Note: Excel …

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 …

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 look or work …

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 …