We strongly recommend our definitive guide if you want to learn all about conditional formatting. Now let us see how to apply conditional formatting using QAT. Formatting Ranges using Quick Analysis Tool You can choose from the following tools: Formatting, Charts, Totals, Tables, and sparklines. If you like using Excel shortcuts, apply the Ctrl + Q combination.Ĭlick the Quick Analysis button on the bottom-right corner of the range. From now the QAT toolbar will appear by default. Check Show Quick Analysis options on selection. You can choose two methods to activate the tool. How to turn on the Quick Analysis feature? Quick Analysis with TOTALS ( Sum, Average, Count, Running Total).Formatting Ranges using Quick Analysis Tool.How to turn on the Quick Analysis feature.Today’s lesson will explain how to use this feature in Excel. If you change the text in a cell, so that it contains 'Oil', the formatting automatically changes.Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines) I am leaving the formatting set to the default.Īnd the cells that contain 'Oil' are formatted in red. Notice the formatting options for text are different than those for money.įormatting options differ between many different types of data. You can also apply conditional formatting to text. Select the cells, click the button, and click another format option, such as Icon Set.īy default, these indicate the upper third, middle third, and lower third of the values.

You can apply multiple conditional formats to the same cells. When I move across the formatting options, a live preview shows me what my data will look like.ĭata Bars provides what I want, so I click it.Īnd now, I have an eye catching visual representation of the data, making it easier to analyze. I select the range of cells in Sales, click the Quick Analysis button, use the default FORMATTING tab. I want to see how much each Salesperson sold.

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

Quick analysis button off