Conditional formatting in Planarly gives you full access to the Planarly language to control the appearance of cells.
The basic model for conditional formatting is that you are creating a table of CSS properties and values that will be applied cellwise to your region of interest.
The structure of that table is important. The cells in the first column are interpreted as the CSS property to be set. The cells in the rest of the columns are interpreted as a table of values to be applied to your region of interest.
In the case of a size difference between your region of interest and the table of values Planarly uses Tile() to unify the table dimensions. This is how effects like alternating rows of color are achieved.
To start with conditional formatting you need to reveal the Properties panel. From the View
menu select Show Properties
.
The Properties panel allows you to set the properties for multiple cells and regions. You specify the label of the cell in the top left corner of the region in the from
input, and the label in the cell in the bottom right corner of the region in the to
input. The formula that will perform formatting is placed in the Code
input.
In the examples that follow we will be using the table #a
, with a from
value of a
and a to
value of Za
. If you're new to labels seeing the Editing cells and cell labels tutorial.
For quick and easy formatting Planarly's table concatenation operators can be used directly in the Code
input.
Below, columns of alternating color are created by the horizontal (or columnar) concatenation of the property background
with two color values. Planarly uses the resulting two column, single row table of gray & orange
to set the background color for all the cells in the region #a
.