The snapshot below shows the conditional formatting presets. As you can see, there are three different types of presets: Data Bars, Color Scales, and Icon Sets.ĭata bars are bar graphs that appear in cells. The bar graph represents the value in the cell.Ĭolor Scales change the background color of a cell based on its value. Return to the Home tab and the Conditional Formatting dropdown box. To apply a conditional formatting preset, start out by selecting your cells just as we did in the last section. Conditional Formatting PresetsĬonditional formatting presets give you additional ways to create visualizations of your data using colors, bars, and icons. These can not only help you visualize your data, they can also dress up your worksheets and make them look more attractive. If you want, you can adjust the percentage up or down. You can also change the highlight color for the cells.Īs you can see, our top 10% values were highlighted. Select if you want Excel to highlight the selected cells that have the top ten values, the top 10% values, the bottom ten values, the bottom 10% values, above average values, or below average values. To apply Top/Bottom Rules, go to the Home tab. In the Conditional Formatting dropdown menu, select Top/Bottom Rules. When you apply top/bottom formatting, you instruct Excel to highlight cells that hold the top values in your selected data – or that hold the bottom values in your selected data.

We have chosen to have any cells with a value greater than 23 to be have a light red fill with dark red text.Ĭlick the OK button when you are finished.Īs you can see, all cells with a value greater than 23 are highlighted in red. Then choose how you want to highlight those cells.

Any other value that is greater than this value will be highlighted. Notice that you can also apply highlighting by finding text, dates, or you can even highlight duplicate values in your worksheet. Select if the conditional formatting rule you want to apply will require that the data be greater than, less than, between, or equal to. Next, we go to the Home tab and click the Conditional Formatting dropdown arrow. To do this, we are going to select our data. While we could just look at the data to find that out, it is much easier to use color coding to highlight the data. We want to apply conditional formatting to this worksheet by color coding cells to find out who is selling more than the required quota. In this article, we are going to learn more about conditional formatting. Conditional formatting is another way to visualize your data. For example, you can color code cells based on their value.

Conditional formatting excel 2016 text