Selecting data using conditional formatting. Conditional formatting: Microsoft Excel tool for data visualization Rules using formulas

Lesson 8. Cell formatting

You can change the cell format, remember it and apply to another table. First consider the possibilities for the formatting of the cell. To do this, select multiple cells, then right-click on them and call modeFormat cells.

As you can see the window contains several tabs. TabNumber allows you to specify the data format in the cell. It is usually rarely changing. As a rule, when entering data into the cell, the program itself determines the format. In fieldNumeric formats You can see it.

Alignment tab allows you to install: where the text will be in the cell. Suppose we scored the text into the cell.

As can be seen from the figure, the text is adjacent to the left border of the cell. In order to put it in the center, you need to set the parameter cENTERin fieldhorizontally .

Interesting orientation mode , It allows you to print the text not horizontally, but in another direction. Suppose you need to change the direction to the horizontal axis by 45 degrees. To do this, install an arrow in the fieldOrientation , as shown in Fig. below.

As can be seen from the drawing, the text direction has changed only in the cell to which the mode is applied. In addition, the size of the string has changed and has become more. The right cell contains text, and it is at the bottom border. To install it elsewhere, select the second cell and use the modeFormat of cells, tab alignment. There in the field vertically set the value - at the top edge.

And the text will move above.

Interesting the width of the width, which allows the program to automatically increase the cell size (horizontally and vertical) if the value is beyond the framework available. For example, we will increase the font size up to 24 in the table created at previous lessons with the operating parameter of the auto-matching.

It can be seen that the size of the vertical (lines) has changed upwards. So lines under the table have a smaller size than where there is a table. Note that the type of font in the title is different, as it is increased by size (width) of the cell.

On the Font tab it is possible to set the type of font, its drawing, size, color, to install it as a crossed, pastor, substitution.

We install in the example above in the title font of one style (Arial), I will install it in bold, make an underscore and choose blue color. To do this, select the header cells and set the parameters, as shown below.

In the Sample field you can see how the text will look like.

Now I will again select the title of the table, remove the tick in the autolation parameter of the width, we get the following picture.

As the text can be seen on the text of other cells. We use the regimeFormat on the Home tab.

In the panel that appears, select the modeField of text width. We get:

On the Border tab, you can set borders around the cell. Suppose we have several cells, as shown in Fig. below.

Highlight them and use the tab.The border .

We chose the color - orange, line type - double and pressed the button external.

Now I will send the table again, and we will use the tab againThe border .

We chose another color, line type and pressed the internal button. It was possible not to leave the boundaries setting mode, set the color, line type, click on the button external, then change the line type, color and click on the button internal.

Tab Fill allows you to install cells. Redest the previous cells and set the color. You can choose the color and then the cells will be painted with a homogeneous color, but we chosePattern and to it color pattern.

Saving styles of cells . Suppose that we will use the resulting style when creating the following tables. Therefore, select four cells again and click on the button.Styles of cells on the Home tab.

It already has styles installed in the program, but we need to create your own style. So click on the inscriptionCreate the style of cells.

A window will appear on the screen in which there are elements for which your style is created, let's call it Try. Put the tick in all switches and click on the buttonOK . Now the new style will be remembered in the program and when you call the modeStyles of cells then it will appear in the list Custom.

Then, when you need to use a new style, select the cells and use the modeTry . After that, the new table will take a new style.

Sometimes it is required to highlight the numbers depending on certain conditions. So, in the table presents comparative data on the categories of the population, abusing certain products, then persons inclined to alcoholic beverages, it is better to highlight in inclined fonts, vegetarians, eating foods with a garden with an emphasis, and consuming a large amount of food that consumes uncontrollab. In addition, the use of color format can be dictated by some conditions. For example, if the temperature in the apartment in the winter does not rise above 0, then the number of such apartments is better to show blue, at a temperature of 0 - 10 degrees - green, with a range of 10 - 20 degrees - yellow, and over 30 degrees - red.

Let's return to the table created earlier. Select part of the table with numerical values \u200b\u200band use the mode on the tabHome → Conditional formatting. The mode window appears on the screen, the view of which is shown in the figure. In this window, choose the modeCreate a rule.

A window will appear in which set values \u200b\u200bfor the rules.

We will put the task to have the color of the background of the cells depending on their value. Choose the upper rule Format all cellsbased on their values \u200b\u200band click on the button.OK .

If you change the color to blue, we will get the following table.

Select the mode in the format style - tricolor scale and click on the buttonOK .

In these modes, you can change the average value by entering the value using the keyboard, but you can also specify the cell in which this value is positioned by pressing the button.

You can set the value bar graph. Then the cells will be filled with the specified color depending on their value.

You can install icons near the values \u200b\u200busing the mode - sets of icons.

You can perform conditional formatting not with the entire table, but with its part. There are other modes. For example,Conditional formatting→ Rules for allocation of cells→ Between

In the window, all values \u200b\u200bthat are located between 25 and 72 will be highlighted with light red fill and dark red. These values \u200b\u200bcan be changed by entering them from the keyboard.

In the list of values \u200b\u200bto which you can change the format there is a custom format, where you can change the type of font, drawing, etc. For example, you can draw in the bold.

Note that you can use several rules for one table.

In this lesson, we consider the basis for the application of conditional formatting in Excel.

With it, we can highlight the color values \u200b\u200bof the tables on specified criteria, search for duplicates, as well as graphically "highlight" important information.

Conditional formatting basics in Excel

Using conditional formatting, we can:

• picture Color
• change font
• set the format of borders

It is possible to apply it to one and several cells, rows and columns. We can use the format using conditions. Next we will practice in practice how to do it.

Where is the conditional formatting in Excel?

The "Conditional Formatting" button is on the toolbar, on the Home tab:

How to make conditional formatting in Excel?

When applying conditional formatting, the system needs to set two settings:

• What cells you want to set the format;
• For what conditions will be assigned a format.

Below, we will look at how to apply conditional formatting. Imagine that we have a table with the dynamics of the dollar in rubles per year. Our task is to highlight in red those data in which the course decreased in the previous month. So, we will perform the following steps:

• In a table with data, we highlight the range for which we want to apply the selection by color:

• We proceed to the "Home" tab on the toolbar and click on the "Conditional Formatting" item. In the drop-down list you will see several types of format to choose from:
  • Release rules
  • The rules for the selection of the first and recent values
  • Histograms
  • Color scales
  • Sets of icons
• In our example, we want to highlight the data with a negative value. To do this, choose the type "Rules for selecting cells" \u003d\u003e "Less":

Also, the following conditions are available:

1. Values \u200b\u200bare greater than or equal to any value;
2. Allocate text containing certain letters or words;
3. Duplicate color
4. Select certain dates.

• In the pop-up window in the "Format cells that smaller" specify the value "0", since we need to highlight the negative values. In the drop-down list on the right, select the format of meets the conditions:

• To assign a format, you can use preset color palettes, as well as create your own palette. To do this, click on item:

• In the format pop-up window, specify:
  • color fill
  • font color
  • font
  • borders of cells

• Upon completion of the settings, click OK.

Below is a table example with conditional formatting according to the parameters we specify. Data with negative values \u200b\u200bare highlighted in red:

How to create a rule

If preset conditions are not suitable, you can create your own rules. To configure the following steps:

• We highlight the data range. Click on the "Conditional Formatting" item in the toolbar. In the drop-down list, choose the item "New Rule":

• In the pop-up window, we need to select the type of rule applied. In our example, we will use the type "format only cells that contain". After that, set the condition to allocate data, the values \u200b\u200bof which are more "57", but less "59":

• Click on the "Format" button and set the format as we did in the example above. Click "OK":

Conditional formatting by the value of another cell

On the examples above, we set the format cells based on their own values. In Excel it is possible to set the format based on the values \u200b\u200bfrom other cells. For example, in the table with the dollar's course we can allocate the color of the cell according to the rule. If the dollar rate is lower than in the previous month, the value of the course in the current month will be highlighted by color.

To create a condition for the value of another cell, we will perform the following steps:

• We highlight the first cell to assign the rule. Click to "Conditional Formatting" on the toolbar. Select the condition "less".
• In the pop-up window, specify a link to the cell with which this cell will be compared. Select format. Press the "OK" button.

• Re-select the left mouse button to the cell, which we have assigned the format. Click on the item "Conditional Formatting". Select in the drop-down menu "Rules" \u003d\u003e click on the "Change rule" button:

• In the field on the left pop-up window "Clean" link from the sign "$". Press the "OK" button, and then the "Apply" button.

• Now we need to assign a configured format to the other cells of the table. To do this, select a cell with a assigned format, then in the upper left corner of the toolbar, click on the "roller" and assign the format to the rest of the cells:

In the screenshot, the color is highlighted in the color in which the currency rate has become lower to the previous period:

How to apply multiple conditional formatting rules to one cell

It is possible to apply several rules to one cell.

For example, in the table with the weather forecast, we want to paint the temperature indicators in different colors. Color allocation conditions: If the temperature is above 10 degrees - green, if above 20 degrees - yellow, if above 30 degrees - red.

To apply several conditions to one cell, we will perform the following actions:

• We highlight the range with the data to which we want to apply conditional formatting \u003d\u003e by click on the "Conditional formatting" item on the toolbar \u003d\u003e Select the selection condition "more ..." and specify the first condition (if more than 10, then green fill). The same actions will repeat for each of the conditions (more than 20 and more than 30). Despite the fact that we applied three rules, the data in the table is painted in green:

Conditional formatting in Excel is an excellent tool for quickly visual data analysis. In this way, the information is much more convenient and easier to evaluate. Moreover, all this happens in automatic mode. The user does not need to think and compare the values \u200b\u200bon their own. Editor will do everything himself. In no formula you can do this that this tool can.

In order to take advantage of this feature, you need to go to the Home tab and click on the "Conditional Formatting" button.

The main sections of this menu include:

• rules for the allocation of cells;

• the rules for the selection of the first and recent values;

• histograms;

• color scales;

• sets of icons;

Consider these items more carefully. To do this, create some table in which you can compare numeric values.

This section also has a lot of different formatting options. We will analyze each of them.

More

1. To begin with, highlight some kind of line. In this case, these will be affected in the first mine.

1. Then go to the Home tab and click on the Conditional Formatting button. In the menu that appears, click on the item "Rules of Cell Selection". Then choose the option "more".

1. After that, a window will appear in which you want to specify the value to compare the selected items. You can drive anything or click on some cell. Click on the average value. This indicator is quite suitable for comparison.

1. Immediately after that, the link to the cell will be set automatically (and it will be separated by a dotted line). To insert, click on the "OK" button.

1. As a result, we will see that the cells in which the value is greater than 27, they were highlighted with different color.

If you do not like the color of the pouring cells, you can always change it. To do this, choose any other coloring option at the indication of the number for comparison.

If any of the proposed options you do not like, you can click on the "Custom Format ..." item.

Immediately after that, a window appears in which you can specify the cell format you need.

1. Highlight some kind of line. Click on the "Conditional Formatting" icon located on the Home tab. Select "Rules for selecting cells", and then "less".

1. You will again offer to specify the cell for comparison. To do this, make the left mouse click on the desired cage.

1. As a result, a substitution of the desired address will occur. To save the settings, click on the "OK" button.

1. As a result, we see that all cells whom the value is less than 24, stood out with different color.

1. Highlight some line without formatting rules. We go into the same section of the menu, but this time I choose the item "Between".

1. Then the EXEL editor will offer any intermediate values. You can leave everything unchanged.

1. Or substitute something your own, more convenient for you. For example, more than 14, but less than 17. To save, click on the "OK" button.

1. As a result, everything that is located between these numbers has been separated by another color.

1. Select another cell free from formatting. We do the same path on the toolbar and select the item "equal."

1. We will be asked to specify a link to the cell for comparison or the ready-made numeric value. We introduce, for example, the number 18. Since it is found in the highlighted line. To save, click on the "OK" button.

1. Due to this, the cell that corresponds to the specified value has become distinguished by another color.

1. To check, you can try to change something. For example, take the adjacent cell. Let's fix there 19 to 18. After clicking on the Enter key, you will see the following.

We see that the background of the cells changes completely in automatic mode.

Text contains

The actions described above are suitable only for numerical values. To work with text information, you need to select another tool.

1. First of all, select some row with several numbers. Then, with the help of a friend, select the menu, select "Text contains ...".

1. As a result, a window will appear in which you need to specify some fragment of the text. It can be a letter or digit. For example, we introduce the number "2". To save formatting, click on the "OK" button.

1. As a result, cells were distinguished with numbers 20 and 23, since both of them have a number 2.

Such manipulations can be done with temporal values.

1. To begin with, add a line in which you write several dates. It is desirable that they go in a row. It will be easier to compare.

1. After that, we allocate all this string. Then go to the "Conditional Formatting" menu and select the "Date" item.

1. Immediately after that, a window will appear in which you can select several options:
   • yesterday;
   • today;
   • tomorrow;
   • over the past 7 days;
   • last week;
   • this week;
   • next week;
   • last month;
   • this month;
   • next month.

1. As an example, choose the option "Tomorrow". To save, click on the "OK" button.

1. As a result, the field containing tomorrow's date will be highlighted by another color.

1. Current date at the time of writing Articles - February 25, 2018.

To demonstrate this conditional formatting it is desirable to use a table without other comparison rules. Next, you will need to perform the following steps.

1. Highlight the main values \u200b\u200bto somehow analyze in the table.

1. Click on the "Conditional Formatting" icon and in the "Code Selection Rules", select "Repeating Values".

1. Immediately after that, a window will appear in which you can choose two values:
   • repetitive;

• unique.

In each case, a preview will be available so that you can accurately decide what exactly you need. To save, you need to click on the "OK" button.

In addition to the usual allocation of specific numbers, there is the possibility of marking a certain number of elements in a percentage or quantitative ratio. To do this, do the following.

1. Select the contents of the table. Then you need to click on the "Conditional Formatting" button, which is located on the Home tab. After that, select "Rules for the selection of the first and last values." As a result, you will be offered several selection options.

Consider each of them.

Selecting this item, you will see the window in which you will be offered to specify the number of first cells. Click on "OK" to save.

The countdown occurs from the greater value to the smaller.

This means that if you need to select the first 10 cells in which the smallest numbers are located, then you need to select the "last 10 elements" item.

During the input of the number of cells, you will be available preview. If you specify the number 1, then only 1 maximum value will remain.

Please note that if there are two cells with the same largest number, both!

In this case, everything works in practically the same principle, only this time is not a specific fixed amount of cells, but only a certain percentage of them.

If you specify the number 10 (it is used by default), then you will see the following.

If you like this formatting rule, you need to click on the "OK" button. Otherwise, click on "Cancel".

The last 10 elements

As mentioned above, in this case there are those cells that contain minimal data. The principle of input is the same - specify the right amount and click on the "OK" button.

If you specify only 1 cell, but the minimum digits will be several, then everyone will be released (in our case - two).

The same principle, only this time a certain percentage of information is highlighted, and not an absolute amount.

This tool is very convenient when you need to sort the information relative to it. That is, the Excel editor himself considers the average among the allocated information and lands everything above this value. Everything happens automatically.

A similar principle of operation and in this case. Only this time the cells are labeled in which information is stored less than the average value.

In the above-described data comparisons, the method of solid fill elements was used. Sometimes it is not entirely convenient.

For a more advanced analysis of information, another tool is used - histograms. At the same time, the fill can be two types:

• gradient;
• solid.

Consider each of the proposed options.

Gradient fill

1. First of all, it is necessary to highlight the desired lines and columns. Then click on the "Conditional Formatting" icon. After that, go to the "Histograms" section and choose any of the proposed fills.

The default values \u200b\u200binclude:

• green;
• red;
• orange;
• blue;
• purple.

When you hover for each option, you will be available preview.

This type of marking is not very different from the above and is located in the same section.

Colors are used the same.

If you did not like any of the proposed items, you can specify your formatting option.

Here you can customize:

• style;

• minimum and maximum value;

• appearance of column.

A sample of what you set up can be seen in the lower right corner.

If you want something more contrast, you need to do the following actions.

1. Highlight the table (basic information for data analysis). Click on the "Conditional Formatting" icon, which is located on the "main" tab on the toolbar. In the menu that appears, select "Color Scale". As a result, a large list of 12 design options will appear.

1. When you hover on each template you will see a similar explanation.

When you hover for each of the icons, you will be available preview. So you can choose the color gamut that you like most.

If you didn't like any of the Excel prescribed by the editor, you can always create something your own. To do this, you need to click on the "Other Rules" menu in the same section.

Immediately after this you will see the following window. Here you can specify the initial and finite color. To save, it is enough to click on the "OK" button.

If you don't like the color formatting, you can use a graphic method. To do this, you need to do the following actions.

1. Highlight the main cells of the table.
2. Click on the toolbar to "Conditional Formatting".
3. In the menu that appears, select the category "Sets of Icons".
4. Immediately after that you will see a large list of different templates.

It is worth noting that the editor itself automatically divides the data into several groups: minimum, average and maximum.

Possible options include (every time you hover on any icon you will see a preview without saving the formatting rule):

• directions (about large numbers arrow up; for medium - right; minimum digits correspond to the down direction);

• figures (color depends on the number in the cell - gray color for the largest values);

• indicators (tick - high, exclamation mark - medium, and cross-minimum);

• estimates (the degree of filling the element depends on the number in the cell);

If none of the icons you did not like, you can create your own cell filling rule.

In this case, you can specify the following parameters on your own:

• icon style;

• your version of the icon;

• boundary values \u200b\u200bfor icons;

To save, click on the "OK" button.

If your experiment failed and the manipulation you did only spoiled the appearance of the table, then all this can be canceled in a fairly simple way.

1. First you need to select those elements whose conditional formatting must be disabled.

1. Then click on the Home tab on the Conditional Formatting icon.
2. After that, select Delete Rules.
3. Next, click on "Delete rules from the selected cells".

1. If you want to delete everything, you allocate the second item - "Delete rules from all over the sheet."

1. The result will be the following. Everything will come back to your own mind.

A set of formatting methods can be changed by your own. This is done as follows.

1. Click on the "Conditional Formatting" button.
2. Select "Rules Management".

1. In the rules manager that appears, nothing will be (if you did not allocate anything before calling this menu), since the "Current Fragment" item is selected by default.

1. Select "This sheet".

1. As a consequence, you will see all the rules that are used in the document at the moment.

Removal

In order to delete anything, it is enough to choose something from the list and click on the "Delete Rule" button.

It is necessary to be very attentive when performing such actions, since you will not ask you, whether you are confident in your choice.

The change

Edit rules is quite simple. This is done as follows.

1. Select any line.
2. Click on the "Change Rule" button.

1. As a result, you will see the following window. By default, the type "format only those cells that contain" is selected.

1. Here you can specify what exactly they contain:
   • text;
   • dates;
   • empty;
   • non-empty;
   • errors;
   • no mistakes.

Conditional formatting is an Excel tool that serves to assign a special format to cells or entire cell ranges based on the criteria of the conditions defined by the user. You will get acquainted with the examples of using conditions based on complex formulas. And also learn how to control such functions as:

• data fields;
• color palette;
• setting fonts.

Learn to work with the values \u200b\u200bthat can be inserted into the cells depending on their contents.

How to make conditional formatting in Excel

To begin with, consider: how to select the corresponding formatting criteria and how to change them. The principle of its action is the easiest to understand on the finished example:

Let's say the column contains the range of cells with numeric values. If you define them with a corresponding formatting condition, then all values \u200b\u200bwith a number of more than 100 will be displayed in red. To implement this task, this Excel tool will analyze in accordance with the terms of the criteria the value of each cell of the specified range. The results of the analysis give a positive result, for example (A2\u003e 100 \u003d truth), then a predefined new format will be assigned (red). In the opposite result (A2\u003e 100 \u003d false), the cell format does not change.

Naturally, this is a fairly simple example. To familiarize yourself with the wide possibilities of conditional formatting only while using it in large data sets with a complex structure, in which it is difficult to even notice the specific values. The ability to use formulas as a criterion to assign a cell format, allows you to create complex conditions for quick search and exposure of numeric or text data.



How to create conditional formatting rule in Excel

This Excel tool provides to your order 3 rules for formatting, which can be mutually turned off the values \u200b\u200binappropriate to the specified criteria. The principle of using several conditions in conditional formatting Consider on a simple example.

Suppose in cell A1 is a numeric value of 50:

We define the following conditions for the display format of values \u200b\u200bin A1:

1. If the number is greater than 15, the font will be displayed in green.
2. If the number is more than 30, then the font will be displayed in yellow.
3. If the number is more than 40, then the font will be displayed in red.

We definitely noted that the value 50 in the cell A1 corresponds to all conditions (A1\u003e 15, A1\u003e 30 and A1\u003e 40 \u003d truth). How does the Excel font display a numeric value 50?

The answer is as follows: the format will be assigned the one that meets the latter condition. And therefore it is red. It is important to remember about this principle when more complex conditions need to be designed.

Note. In the old versions of Excel, when determining the formatting conditions, it was necessary to focus its attention to the fact that the conditions are not superimposed on each other. This situation is most often applied when the exposed data should be given to values \u200b\u200bat a certain level. But starting with Excel 2010, there are no restrictions when applying conditions.

Create a second rule

The second example. Suppose we need to format the costs of column with as follows:

All amounts within $ 300 -600 must paint their cells with a yellow background, and amounts less than $ 500 should still have a red font color.

Let's try to construct these conditions:

Pay attention to which Excel method applied formatting. Amounts in cells C10, C13 and C15 correspond to both conditions. Therefore, both formatting styles are applied to them. And where the value corresponds to only one of the conditions, they are displayed to the corresponding formats.

This lesson with examples and video we devote to conditional formatting - one of the most interesting and useful Excel funds.

What is conditional formatting

So, we turn to the point. Conditional formatting is a way to simplify Excel programs as much as possible. This method of information processing allows you to save a lot of time and facilitate all calculations. You can force the program to automatically perform many tasks that were previously done manually, killing on this whole days.

In addition, for your convenience, you can configure the Excel operation so that it immediately highlights the necessary or important information in the documents. In addition, such formatting will help more clearly display information, quickly and effectively create reports without the use of complex graphic models, such as diagrams or graphs.

Let's consider more specific examples of using conditional formatting. In order to apply it to Excel 10, in the Home section, on the top of the program, you need to find the "Conditional Formatting" button. It does not hide anywhere, so it will not be difficult to find it. In order to activate this formatting, we need to highlight the zone on the work sheet with which we will work. It is in mind that before pressing the "Conditional Formatting" button and proceed to it, you need to highlight a bar, row or several of these items for which you want to use formatting.

So, the area zone is highlighted, the button is pressed - what's next? The conditional formatting menu will open before you:

1. The rules for the selection of the first and recent values.
2. Color scales.
3. Additionally: Create, delete, rules management.

What to do with it? Let's in order. This item, in turn, accommodates such standard functions as

• More;
• Less;
• Equally;
• The text contains;
• Date;
• Repeating icons.

Working with these formatting models is completely simple. By clicking on any of them, you will open a small window where you need to enter the data you need and select the color to highlight the tables suitable for you.

1. Click "between" and in the new window that opens in the corresponding cells, enter the parameters from and to.
2. Then point the color you want to highlight the options suitable for you (let it be "light-red fill and dark red text"). That is, if you work with a pillars for mobile phones, then enter the numbers of the minimum and maximum cost, which suits you (let it be 50 and 100).
3. After you confirmed that it is between these values \u200b\u200bthat you want to start a search, the cell table is highlighted accordingly and we will see all cells with a price from 50 to 10 dollars painted in light red color and with dark red text.

All this is quite simple when in practice, proceed to work with the program.

All formatting methods in the menu "Rules for the selection of cells" work approximately the same way, so we will not stop here.

The rules for the selection of the first and recent values

The next point in front of us. How it works? If you need to select the several first or last cells on the entered data, then you are where necessary. There is nothing more to explain here, so we turn to the example.

1. By pressing the "first 10 elements", we will call a window where you can manage this formatting.
2. Here, point out the number of cells that we need to highlight: it was originally called 10, but we only need 5, so correct it in the corresponding field.
3. Then we choose the color of formatting: let it be "the red border".
4. Then 5 cells with the largest values \u200b\u200bwill be highlighted in a red frame.

Let's go further. Everything is very simple here. You just need to select the column or line you need and click on the corresponding button. Then we will see how all cells are more or less filled with color, depending on the values \u200b\u200bwithin them. This is like a real histogram.

• We press the "histogram" and choose any model you like in the menu (they differ only in the design).
• As a result, our column with the number of phones will change in such a way that the largest digit on the entire cell will be filled with color completely, and everyone else will be filled into a percentage ratio to the maximum value.

Color scales

Allow you to decorate our cells in ascending or decreasing the values \u200b\u200bin them. You only need to choose in what color scheme it will happen (for example, the maximum value is green, the minimum is red, and all intermediate values \u200b\u200bwill be painted into the corresponding transition shades). There will not be even an example here.

Icons are needed in order to indicate the difference between the values \u200b\u200bin our column or line. Theoretically explain a little difficult, so we will immediately move on to the examples.

• we choose "sets of icons" and in the section "Directions" by clicking on "5 color shooters". Thus, in each cell of the field in which we work, one of the 5 types of arrows will appear.
• Explain how they work: the entire range of values \u200b\u200bin the cells allocated by us is 100%, and each day of the arrow is responsible for the numbers that are included in every 20% in order. Let us in the column of the number of phone purchases there are values \u200b\u200bfrom 0 to 100. Then the first arrow (green up) will stand near each value from 80 to 100, and the last (red down) - near each from 0 to 20. Accordingly, all intermediate arrows.

The percentage ratio or the entire range can be configured in the "Rules Management" menu, you can also play with the settings of the remaining rules.