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

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.

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 …

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 color, or icon that you …

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, appointments, and email …

Conditional formatting quickly highlights important information in a spreadsheet. But sometimes the built-in formatting rules don’t go quite far enough. Adding your own formula to a conditional formatting rule …

Watch this video to learn how to Use conditional formatting on reports. Open the form or report in Layout view, and select the control where you want to apply the conditional formatting.

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. This can help …

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 duplicates. Note: 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 your choice.