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.

Examples of conditional formatting

To start with conditional formatting you need to reveal the Properties panel. From the View menu select Show Properties.

Screenshot 2021-11-04 at 15.53.41.png

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.

Screenshot 2021-11-04 at 15.54.10.png

Conditional formatting with pre-defined tables

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.

Screenshot 2021-11-04 at 14.53.30.png