Outlook CRM Background

How to Highlight Cells

Using Conditional Formatting in eWay-CRM.

Conditional formatting in eWay-CRM enables you to highlight cells with a certain color, depending on the cell’s value.

You can use it everywhere – to highlight all leads overdue, projects with price lower than the estimated one, contacts with activity older than 6 months, important companies, etc. There are no limits to your imagination.

To highlight cells that are greater than a value, execute the following steps.

  1. Right click a column, for example, Estimated Revenue.

Estimated Revenue Column

  1. Select Conditional Formatting> Highlight Cells Rules> Greater Than…

Set Conditional Formatting

  1. Enter the value (for example, 1000) and select a formatting style.

Set Conditional Formatting

Optionally, you can apply the formatting to the entire row.

  1. Click OK.

As a result, eWay-CRM will highlight the cells that are greater than 1000.

Conditional Formatting Example

Or entire rows that contain cells that are greater than 1000.

Conditional Formatting Example

Note: you can also highlight cells that are less than a value, between a low and high value, etc.

To clear a conditional formatting rule, right click a column and select Conditional Formatting > Clear Rules > Clear Rules from This Column or Clear Rules from All Columns.

Delete Conditional Formatting

Do you have questions? Our consultants have answers.

Do not hesitate to contact us.