Create a conditional formula that results in another calculation or in values other than TRUE or FALSE To do this task, use the IF, AND, and OR functions and operators as shown in the following example. …

Using AND, OR and NOT with Conditional Formatting in Excel In Excel, you can also use AND, OR and NOT to set Conditional Formatting criteria with the formula option. When you do this you can omit the …

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly …

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 …

Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a …

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 makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria).

Jun 3, 2026 · In current Excel, the options that used to be labeled “Format cells if…” are under Conditional Formatting on the Home tab. To access them: Select the cells to format. Go to Home > …

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.

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

You cannot create custom conditional formatting rules to apply shading to alternate rows or columns in Excel for the web. When you create a table in Excel for the web, by default, every other row in the …

A conditional column calculates a value from a formula. In Power Query, the term used is custom column. In this section, let’s create a 2.5% bonus calculation for all sales over $25,000. To do this, …

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …

With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When the conditions are fulfilled, the conditional column will automatically …

When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine which cells to include in the calculations, consider using the …

To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group. Learn about filtering for unique values or removing duplicate values Filtering for …

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.

Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the values of a range of cells at the same time. …

If the data you want to filter requires criteria across multiple fields, such as filtering by multiple conditions that must all be true, or showing rows that match any of several different conditions (such as Type = …

These can also be used in the Conditional Formatting rules that use the "Only format cells that contain specific text" criteria. For more information about using wildcard characters with the Find and …

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 …