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 …

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.

Conditional formatting in classic Outlook for Windows allows you to automatically change incoming message colors and fonts based on sender, subject, or recipients.

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.

If you'd like to give your calendar a brighter, more visually dynamic look, you can use conditional formatting to color-code your appointments and meetings based on sender, location, or whether the …

Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect …

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 (...) next to …

This can help you see patterns and relationships in the data that might be hard to spot otherwise. This video demonstrates adding some simple conditional formatting rules to highlight certain ranges of …