conditional formatting
In Application Studioyou can format data according to
whether it meets a condition, or if the product of a formula in other cells meets a
specified condition. Several different conditions can be set for a single cell. The first
true condition is applied. Whether a cell is editable can also be made conditional.
Conditions can be values or the products of formulas. You can use a mix of value and formula
conditions in a single cell.