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.
0 Comments
Leave a Reply. |