You are here: Home / Documentation / 3. Description / 3.2 List of Items (Data) / Conditional Formatting

Conditional Formatting

eWay-CRM allows you to use conditional formatting similar to Microsoft Excel. Colors, icons, data bars and color scales will make your data even more well-arranged. You will be able to find important information at a glance.

Default Conditional Formatting

Each eWay-CRM module has a predefined rule or a set of predefined rules that can be applied by selecting the Default view at the bottom part of the list of items.

The table below shows default rules that have been applied to both list of items and the tab system.

ModuleDefault rules
Marketing

Completed/lost items are displayed as crossed out with a gray font.

Overdue items that are not completed/lost are highlighted with a red font.

Deals

Completed/lost items are displayed as crossed out with a gray font.

Overdue items that are not completed/lost are highlighted with a red font.

The "Probability" column has a data bar–the higher a value the larger the bar.

The "Price" column is highlighted in green–the higher a value the darker color.

Projects

Completed/lost items are displayed as crossed out with a gray font.

Overdue items that are not completed/lost are highlighted with a red font.¨

The "Price" column is highlighted in green–the higher a value the darker color.

Bookkeeping Records*

Bookkeeping records of the purchase invoice, sales invoice, sales proforma invoice, purchase proforma invoice, debit note, and credit note type:

  • Overdue items that are not paid are highlighted in a red font.
  • Paid items are displayed as crossed out with a gray font.

 

Bookkeeping records of the issued proposal and received proposal:

  • Processed/lost items are  displayed as crossed out with a gray font.

 

Users Items with the status "Inactive" are displayed as crossed out with a gray font.
Leaves Items with the status "Accepted" are displayed as crossed out with a gray font.
Bonuses Items with the status "Accepted" are displayed as crossed out with a gray font.
Goals Overdue items are displayed as crossed out with a gray font.
Salaries Overdue items are displayed as crossed out with a gray font.
Time Sheets* Items with the status "Accepted" are displayed as crossed out with a gray font.
Exchange Rates Overdue items are displayed as crossed out with a gray font.
Tasks*

Items that are not overdue or completed are displayed with a gray background.

Overdue items that are not completed are highlighted with a red font.

Completed items are displayed as crossed out with a gray font.

Calendar*

Items that are not overdue or completed are displayed with a gray background.

Overdue items are displayed as crossed out with a gray font.

* The same rules have been applied on HUBs in the tab system and in the eWay-CRM HUB.

Custom Conditional Formatting

Apart from default conditional formatting, you can apply additional predefined rules, create your own rules and edit existing rules.

Adding Predefined Rules

eWay-CRM offers a set of additional predefined rules that can be applied with a few clicks. These rules are shown as options when you right click a column header and select Conditional Formatting in the context menu. Types of rules available for columns depend on the type of columns—numeric, text, drop-down menus, etc.

Types of possible rules include:

  • Highlight Cell Rules
  • Top/Bottom Rules
  • Unique/Duplicate Rules
  • Data Bars
  • Color Scales
  • Icon Sets

Example. To highlight all values that are higher than 10,000 in the Estimated price field on Project cards, right click on the column Estimated price and go to Conditional Formatting > Highlight Cell Rules.

Click Greater Than, specify the value in the field, e.g. 10000, in the dialog-box select a type of formatting. To apply formatting to the whole row, check the corresponding box.

Confirm your choice by clicking OK.

As a result, only projects, where Actual Revenue is greater than 10,000 will be highlighted with a red background.

Important: Rules are always related to the column/columns they are applied to. If you hide a column, the formatting will be aborted. If you unhide a column, the formatting will revert.

Creating Custom Rules

If a required rule is not among predefined ones, you can create your own custom rule. To do that, go to Conditional Formatting > Manage Rules:

In the pop-up dialog-box click New Rule.

Select a rule type and and define the conditions.

Clcik OK to apply a rule.

Editting Rules

To edit a rule, go to Conditional Formatting > Manage Rules highlight a rule by clicking on it and hit Edit Rule...

In the new dialog-box select a rule type and edit the rule description.

In the picture above, the rule has been edited to highlight projects with Actual Revenue above 50,000 with a green background.

Deleting Rules

You can delete a rule in two ways:

    1. Right-click the column header where a rule has been applied. Go to Conditional Formatting > Clear Rules. You can clear only rules from this column or from all columns.

  1. Right-click the column header where a rule has been applied. Go to Conditional Formatting > Manage Rules... Highlight a rule you want to delete by clicking on it and hit the Delete Rule button.