Use conditional formatting

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trends based on criteria you provide.

Want more?

Apply conditional formatting to quickly analyze data

Add, change, find, or clear conditional formats

Take conditional formatting to the next level

Conditional formatting provides visual cues to help you make sense of your data.

For example, it'll clearly show highs and lows, or other data trends based on criteria you provide.

I want to see how much each Salesperson sold.

I select the range of cells in Sales, click the Quick Analysis button, use the default FORMATTING tab. When I move across the formatting options, a live preview shows me what my data will look like.

Data Bars provides what I want, so I click it.

And now, I have an eye catching visual representation of the data, making it easier to analyze.

You can apply multiple conditional formats to the same cells.

Select the cells, click the button, and click another format option, such as Icon Set.

By default, these indicate the upper third, middle third, and lower third of the values.

You can also apply conditional formatting to text.

Notice the formatting options for text are different than those for money.

Formatting options differ between many different types of data.

I select Text Contains and enter "Oil". I am leaving the formatting set to the default.

And the cells that contain 'Oil' are formatted in red. They really stand out.

If you change the text in a cell, so that it contains 'Oil', the formatting automatically changes.

Up next, Conditionally formatting dates.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×