Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
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.
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 it easier to compare the values of a range of cells at the …
IF function - Microsoft Support
How to use the IF function in Excel to make logical comparisons between data values.
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Highlight patterns and trends with conditional formatting in Excel …
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 and remove duplicates - Microsoft Support
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 …
Formatting list views - Microsoft Support
This example shows conditional formatting with the status column set equal to "Blocked". You can edit and delete previously created rules by going to Manage rules and selecting the ellipses …
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.