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

Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria,—such as the last cell on …

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.

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 then click …

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 …

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 …

Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be …

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.

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 …

Conditional formatting is a way to make email messages in Outlook stand out when they meet conditions defined by you. When you specify conditions that an incoming message should meet, such as a …