Table of Contents

Coloring by cell

This procedure will show you how to color individual cells (fields) in a navigator.

As an example, we will set all the cells with an amount to pay greater than 7000 BGN to color in red, in the Sales Orders navigator. For this purpose you can go to:

Main Menu -> Sales -> Orders Navigator

The Sales Orders navigator shows the sales orders issued to our clients.

  1. Click on Show Data and then right-click on the rows of the navigator. From the displayed menu select Customize fields;
  2. Select a given field. In this case, click Amount To Pay and then Properties…:

Amount to pay

  1. Field Properties window will open. From here, go to the Format Condition tab and check the Enable Format Condition box. As a condition, select Greater and set Value 1 to be 7 000. After this, you can choose the color - let's choose the red color:

Format condition

The check box Apply To Row gives you the opportunity to only color the selected cell (when it is unchecked) or to color the entire row when the field conditions are met.

  1. Click OK and close the Fields Properties window. Now every cell with an amount to pay over 7 000 BGN is colored in red:

Colored cell