Use conditional formatting to highlight information in Excel
How to use conditional formatting in Excel to visually explore, analyze, and identify patterns and trends.
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.
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 specify conditions that an incoming message should …
Filter by font color, cell color, or icon sets - Microsoft Support
And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting. In a range of cells or a table column, click a cell that contains the cell color, font …
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 salespeople are selling above average, or track who …
Create and assign color categories in Outlook - Microsoft Support
Color categories allow you to easily identify and group associated items in Microsoft Outlook. Assign a color category to a group of interrelated items—such as notes, contacts, …
Video: Use conditional formatting on reports - Microsoft Support
Conditional formatting allows you to apply different formatting to individual values on Access desktop reports, either based on the value itself, or on a calculation that includes other values. …
Using IF with AND, OR, and NOT functions in Excel
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 …
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 …
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 …