Setting Up Conditional Formatting

To set up formatting that is applied only when a specific condition is executed, use the Conditional Formatting group of parameters on the parameters panel:

Open the Conditional Formatting group of parameters

To add a rule, click the Add Rule button, after which the Formatting Rule panel opens:

Available cell formatting rules:

Based on their values.
With definite value.
With greatest/least values.
With values greater/less than average.
With unique/duplicate values.
Satisfying a formula.