You can set up conditional formats within cells that determine the formatting of
the cell based on the outcome of a conditional statement.
You can use a named style to specify various formatting options such as borders
and colors to apply if the condition statement is valid, that is, if the operation
For example, you might want to change the background color of a cell based on the
value of the cell. If the value is below 100 then the background color would be
changed to red. The condition statement is "less than 100" and consists of a comparison
operator "less than" and a condition, in this case a single constant "100". The
condition can be a constant (expressed as a string) or an expression.
Refer to the example below to see how conditional formatting can be set for a range
of cells that would result in different background colors, for instance, depending
on the value in the cell.