naxarchi.blogg.se

As before I highlight the Order Completion column and then select Bottom 10 Items from the menus. These rules are located in the Top/Bottom Rules sub-menu of the Conditional Formatting dropdown.Īs an example I am going to highlight the bottom 10 orders by Order Completion. Its the same as before, just enter the required value but this time Excel is checking whether the values of the County column are equal to United States.Īnother useful conditional formatting rule is to highlight the top or bottom 10, 20, 50 etc. For example I could highlight cells in the Country column where the order is from the United States.įollow the same steps as before but, this time, select Equal to from the Highlight Cells Rules menu. Although filtering may be a more useful tool for this I will demonstrate the functionality. You can highlight a cells value if it contains a certain text value. You can even do custom rules, but this is more on the advanced side of the conditional formatting tool and will be covered in a later tutorial.Ĭonditional formatting doesnt just work on numerical values. There are a number of basic rules here that you can apply to highlight cell values you are most interested in.

Alternatively I could have done Order Totals less than 5000 or between 10, or whatever I wanted. For this tutorial I went with a Green Fill with Dark Green Text.Īs you can see a number of cells are now highlighted as they are over the £5000. There are a number of default options here as well as a custom formats option, should you want to be specific. (5000 in this case) The second box is then the formatting that is to be applied to the cells with values greater than 5000. The first box is the value I want my cells to be greater than. I then navigate to the Highlight Cells Rules sub-menu of the conditional formatting menu. To do this, first I must select the Order Total column.

I am going to highlight orders which are over £5,000 in value. Note that cells which do not meet the rule still keep their original formatting.įor the first example I am going to add a conditional formatting rule on the Order Total column.

If it is false then no formatting is applied. If this rule evaluates true then a certain format is applied to highlight that cell. The Conditional Formatting dropdown is accessed from the Home tab:Ĭonditional formatting involves applying a rule to the value of a cell. I will demonstrate some features of this advanced and powerful Excel tool. To do this I use the Conditional Formatting tool. In this tutorial I am going to cover how to highlight rows that meet a certain condition.