↑ Return to Conditional Formatting

Data Bars and Icons

 

The conditional formatting allows you to add Data Bars and the icons in your cells is function of the result of rules.

 

The Data bars

When you insert a conditional formatting Data Bar, everybody will approve your document. It’s an instant success. ­čśÄ

The method to insert Data Bar in your cells is very simple.

  1. Select your range of cells (1 column or more).
  2. Select one of these options in this menu.

Instantly, your cells are partially fill with a bar in function of the value between the min and the max of the selected range. Change some values in the following document to change the size of bars.


As you can see in the second column, the fill is proportional to values (look at bars for the cells 5, 10 and 20).

The icon Sets

In the same way you can insert icons in your cells to easily identify the best and worst values.

  1. Select your range of cells (1 column or more).
  2. Select one of these options in this menu.

<

You can see, you can choose between 3 or 5 icons.

By default, icons split your data by equal proportion but you can change these parameters with the manager of rules.

Select your rule in the dialog box and click on the button Edit Rule …


And replace the Type Percent by Number. Change the setting of the green icon to 10 and the yellow to 8.

The following document present all changes.

Or you can also use Data Bars for the Time and Split Time of a race





//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js

Leave a Reply

%d bloggers like this: