Welcome to our Documentation
All
Print

Conditional rules

The PubyDoc DataTable and Charts plugin fully supports Conditional rules for both columns and individual cells, and in this tutorial, we will detail how to add and configure Conditional.

What are Conditional Rules?

Often, when working with large datasets, in particular with numeric values, it is very difficult to quickly find and estimate the number of cells with the desired values.
Conditional Rules, also known as Conditional Formatting, is a powerful tool that affects how a cell will look depending on its content.

This option is very useful in spreadsheets with a large amount of numeric data, for example, imagine that we need to find in the table those companies that earned more than $50,000 per month this spring. Surely a manual search will take a lot of time and will bring a lot of errors. This is where we need the Conditional Formatting option.

Company January April February March May June July August September October November December
Cross market $3526 $25277 $400003 $23523 $334737 $23325 $40000 $6856 $23343 $34677 $74574 $235
Guardian $423423 $3423 $55322 $3636 $35232 $32235 $3423 $235 $2353 $454754 $3423 $747362
Prof Nagreyt $523523 $3456 $23456 $45435 $5235 $23523 $2352 $54722 $3473 $3434 $2526 $457
Brentfurio $353532 $2252523 $3535353 $523523 $30000 $26344 $756745 $56457 $575474 $56568 $2346 $8567
Becrandof Ind $3525 $2352 $5235 $2352352 $40000 $30000 $20000 $60000 $10000 $20000 $400003 $100001
Yellow BrenInd $535675 $80000 $3535 $8765 $87654 $32565 $80000 $24211 $352235 $5835 $80000 $75379
ChikMafdery $3525 $52353 $26267 $3523535 $342334 $342323 $3233 $242421 $22321 $35253 $347373 $3525
CoffeeBar $3535 $40000 $3535 $400003 $352367 $3426 $40000 $74774 $35353 $65543 $40000 $547547
Green planet $3525 $23567 $3252 $21412 $678909 $34734 $30450 $45678 $21421 $290936 $35784 $3525
Meow brain $235 $3532 $236262 $23523 $57457 $3474743 $3423 $79679 $7976 $67967 $253 $457
Teresa ind $223 $30450 $2345 $32556 $3364 $352 $30450 $23523 $53531 $34235 $30450 $457
Daifro Port $3432 $3434 $355362 $35353 $54532 $36646 $5790 $353523 $342352 $46346 $343657 $35678
Oslo Comp $3535 $30000 $3535768 $2352 $3535 $400003 $30000 $253235 $3252 $3473 $30000 $5747
PC Lorent $568943 $68685 $56886 $34322 $400003 $45454 $35254 $23455 $34567 $34576 $34567 $24435
Brauhaus corp $235235 $535235 $23523 $2637547 $643555 $475889 $45545 $445432 $457547 $565474 $463433 $732123
Air Gitmarey $8765 $1232 $24424 $21441 $80000 $50400 $10000 $50000 $76890 $87654 $8765 $3457
Neo graphics $3525 $343423 $235326 $2353 $23522 $6345734 $343423 $79679 $35552 $5677 $343423 $457
Phone Dismir $35235 $76943 $34433 $353353 $353 $8765 $76943 $32478 $400003 $423697 $76943 $7454
Gyper Todibo $34567 $23457 $87654 $87654 $8765 $87658 $87666 $87655 $9876 $9876 $9876 $3456
AIA $235662 $235235 $235235 $35235 $30450 $8979 $8987 $6790 $23578 $352522 $352355 $252563

Now let’s take a look at the same table, but with Conditional Formatting applied. Where all values greater than or equal to $50000 will be highlighted in green. Values between $10,000 and $50,000 will be highlighted in yellow. And those companies that have earned less than $10,000 are highlighted in red.
That’s what conditional formatting is: it allows you to highlight or change cells, rows, or even columns based on the contents of the cells.

Company January April February March May June July August September October November December
Cross market $3526 $25277 $400003 $23523 $334737 $23325 $40000 $6856 $23343 $34677 $74574 $235
Prof Nagreyt $523523 $3456 $23456 $45435 $5235 $23523 $2352 $54722 $3473 $3434 $2526 $457
Brentfurio $353532 $2252523 $3535353 $523523 $30000 $26344 $756745 $56457 $575474 $56568 $2346 $8567
Becrandof Ind $3525 $2352 $5235 $2352352 $40000 $30000 $20000 $60000 $10000 $20000 $400003 $100001
Guardian $423423 $3423 $55322 $3636 $35232 $32235 $3423 $235 $2353 $454754 $3423 $747362
Yellow BrenInd $535675 $80000 $3535 $8765 $87654 $32565 $80000 $24211 $352235 $5835 $80000 $75379
ChikMafdery $3525 $52353 $26267 $3523535 $342334 $342323 $3233 $242421 $22321 $35253 $347373 $3525
CoffeeBar $3535 $40000 $3535 $400003 $352367 $3426 $40000 $74774 $35353 $65543 $40000 $547547
Green planet $3525 $23567 $3252 $21412 $678909 $34734 $30450 $45678 $21421 $290936 $35784 $3525
Meow brain $235 $3532 $236262 $23523 $57457 $3474743 $3423 $79679 $7976 $67967 $253 $457
Teresa ind $223 $30450 $2345 $32556 $3364 $352 $30450 $23523 $53531 $34235 $30450 $457
Daifro Port $3432 $3434 $355362 $35353 $54532 $36646 $5790 $353523 $342352 $46346 $343657 $35678
Oslo Comp $3535 $30000 $3535768 $2352 $3535 $400003 $30000 $253235 $3252 $3473 $30000 $5747
PC Lorent $568943 $68685 $56886 $34322 $400003 $45454 $35254 $23455 $34567 $34576 $34567 $24435
Brauhaus corp $235235 $535235 $23523 $2637547 $643555 $475889 $45545 $445432 $457547 $565474 $463433 $732123
Air Gitmarey $8765 $1232 $24424 $21441 $80000 $50400 $10000 $50000 $76890 $87654 $8765 $3457
Neo graphics $3525 $343423 $235326 $2353 $23522 $6345734 $343423 $79679 $35552 $5677 $343423 $457
Phone Dismir $35235 $76943 $34433 $353353 $353 $8765 $76943 $32478 $400003 $423697 $76943 $7454
Gyper Todibo $34567 $23457 $87654 $87654 $8765 $87658 $87666 $87655 $9876 $9876 $9876 $3456
AIA $235662 $235235 $235235 $35235 $30450 $8979 $8987 $6790 $23578 $352522 $352355 $252563

Where can I find the Conditional Formatting option?

In the PubyDoc DataTable and Charts plugin, you can specify conditional formatting for both the entire table and individual columns/rows/cells. It doesn’t matter if you apply conditional formatting to a column or to the entire table, in any case, the setting has the same principle of operation and will not cause you any difficulties.

Let’s start by going to the option, the path to it depends on what you want to apply conditional formatting to. If you want to set up Conditional Formatting for:

  • Column. Then go to the column settings (mouse over the header and click on the settings icon) and open the Conditional tab.
  • One or more cells. Select one or more cells and click on the “Add conditional formatting to cells” option icon.
  • For the entire table. Select all the cells in the table and click on the “Add conditional formatting to cells” option icon.

Thus, you can choose absolutely any range for applying conditions.

How to set up conditional formatting?

Rules.

To begin defining conditional formatting rules, click new conditional rule to create and specify parameters for the condition.

Condition type.

This is determined by what operation you want to use to set the condition. Use text or a cell for the condition, and depending on the type, select a comparison operator. For instance:

Operator.

Select the comparison operator, that is, “How exactly to compare?”.

For the Text type, the operator can be: begin with; end with; contains; not contains.

For the Cell in type, the operator can be: equals; not equals; greater than; greater than or equal; less than; less than or equal; between.

Value.

This is determined by the value that will be used in the rule comparison operation.

Styles.(background; text color).

Here you can select the background color and text when the condition is triggered.

Properties. (Bold; Italic; Underline).

Here you can select proprietes text when the condition is triggered.

After you have specified all the parameters, click Apply and the condition will be added to the list.

How to change/remove given conditional formatting?

This is very simple to do, or rather, in the reverse order of setting the option.
If conditional formatting was set:
Column. Then go to the settings of the column to which you previously set conditional formatting, go to the “Conditional” tab
Cell, or multiple cells. Select the cell or cells that you previously applied conditional formatting to and click on the Add conditional formatting to cells option.

To change the condition, click on the condition from the list and make the necessary changes.
Then click Apply to save the changes to the rule.
To remove a condition, click on the trash can icon on the required condition in the list.
After the changes are made, click save to save them to the table.

Next Extended builder
Options
Shopping Cart