Create conditional formulas | Microsoft Support
Create a conditional formula that results in another calculation or in values other than TRUE or FALSE To do this task, use the IF, …
Using IF with AND, OR, and NOT functions in Excel
Using AND, OR and NOT with Conditional Formatting in Excel In Excel, you can also use AND, OR and NOT to set Conditional …
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the …
Use Conditional formatting rules to change incoming messages in …
Conditional formatting is a way to make email messages in Outlook stand out when they meet conditions defined by you. When you …
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a …
Use a formula to apply conditional formatting in Excel for Mac
Use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which …
Highlight patterns and trends with conditional formatting in Excel for ...
Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the …
Conditional formatting in Excel - Microsoft Q&A
Jun 3, 2026 · In current Excel, the options that used to be labeled “Format cells if…” are under Conditional Formatting on the Home …
Highlight patterns and trends with conditional formatting in Excel for ...
You can use conditional formatting to highlight cells that contain values that meet a certain condition, or format a whole cell range …
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Apply shading to alternate rows or columns in a worksheet
You cannot create custom conditional formatting rules to apply shading to alternate rows or columns in Excel for the web. When you …
Create a conditional column | Microsoft Support
A conditional column calculates a value from a formula. In Power Query, the term used is custom column. In this section, let’s create …
IF function | Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and …
Add a conditional column (Power Query) | Microsoft Support
With Power Query, you can add a conditional column to your query. You can define IF-THEN-ELSE conditions in your query. When …
Perform conditional calculations on ranges of cells
When you need to perform simple arithmetic calculations on several ranges of cells, sum the results, and use criteria to determine …
Filter for unique values or remove duplicate values
To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group. Learn about …
SUMIF function | Microsoft Support
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Use data bars, color scales, and icon sets to highlight data
Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make …
Filter by using advanced criteria | Microsoft Support
If the data you want to filter requires criteria across multiple fields, such as filtering by multiple conditions that must all be true, or …
Using wildcard characters in searches | Microsoft Support
These can also be used in the Conditional Formatting rules that use the "Only format cells that contain specific text" criteria. For …
Find and select cells that meet specific conditions in Excel
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 …