Related topics
×
Use conditional formatting
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Use conditional formatting

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×