Home USU  ››  Programs for business automation  ››   ››   ›› 

Highlighting values with a gradient background

Standard These features are available only in the Standard and Professional program configurations.

Important Here we have already learned how to use Standard conditional formatting with images.

Highlighting large orders using a set of pictures

Gradient using two colors

And now let's in the module "Sales" highlight the most important orders using a gradient. To do this, we use the already familiar command "Conditional Formatting" .

Important Please read why you will not be able to read the instructions in parallel and work in the window that appears.

In the window that appears, the previous condition for formatting data can already be added. If it is, click the ' Edit Rule ' button. And if there are no conditions, then click the ' New Rule ' button.

Change conditional formatting

Next, in the list of special effects, first select the value ' Format all cells based on their values via two color scale '. Then select the colors for the smallest and largest value.

Highlight large orders with a gradient using two colors

The color can be selected both from the list and using the color selection scale.

Two ways to choose color

This is what the color picker looks like.

Color picker

After that, you will return to the previous window, in which you will need to make sure that the special effect will be applied specifically to the ' To pay ' field.

Selecting a field for applying a special effect

This is what the result will look like. The more important the order, the greener the background of the cell will be. Unlike using Standard a set of pictures with such a selection, there are much more shades for intermediate values.

Highlight the most important orders with a two-color gradient

Gradient using three colors

But you can make a gradient using three colors. For this kind of special effect, select ' Format all cells based on their values via three color scale '.

Highlight large orders with a gradient using three colors

In the same way, select the colors and change the special effect settings if necessary.

In this case, the result will already look like this. You can see that the color palette is much richer.

Highlight the most important orders with a three-color gradient

Change Font

Important You can change not only the background color, but also Standard font .

See below for other helpful topics:

Your opinion is important to us!
Was this article helpful?



Universal Accounting System
2010 - 2024