The right formatting and style can make all the difference when presenting information. With the correct formatting, your data will reach your users in a more efficient way. Pigment has broad formatting and styling options including the specific cells, font style, value displaying, and colors within a Table, Metric or List. This article covers Static formatting, we have other articles for Conditional and Layout options.
Where can you apply formatting?
Formatting can be applied to Lists, Metrics, and Tables. When you have any of these blocks opened, you can find the Format button on the top towards the right side of the display panel. It is view specific, meaning the formatting from one view will not carry into another view. You must also save it after applying any format for it to remain on view. If you apply formatting and want to remove it, you can hit the Reset button next to the section, you’ll notice there is one for Style, Values and More options, each controls the formatting of that section.
Formatting is stored at the view level, meaning any applied formatting must be saved to a view. When adding blocks to a board, its important to select the correct view for the formatting to remain.
Formatting specific cells
You can also use all the display options for a specific cell.
Right-click on the cell you want to format and you will see all the options available. If you want to select more than one cell, hold down Command / Control key and you can select more than one cell.
Formatting headers
You can also format grid headers.
When you click on a header it will select the corresponding column(s)/row(s). Right-click on it and select "Format cells". By default, this will be applied to all the selected cells except the header. To also apply this formating to headers, check the "Apply to: Grid header(s)" option.
Formatting multiple Properties or Metrics at the same time
| Directly under the Static heading, you will see a drop-down, this will allow you to select multiple metrics or properties, depending on your view. Once you have selected these, you can apply the same formatting across all selected values. When you have more than 3 metrics, you will see a “Select All”, this will apply the formatting to all the metrics in that table. When applying formatting on multiple metrics, it will not override any previously applied formatting at the cell level. | 
|
Styling options
Background and Text color | 
| If the chain is on, the text and the background will be harmonized. Click on the chain if you prefer a different customization |
Cell borders | 
| Click on the border you want to add |
Font style | 
| B for bold I for italic |
Values options
Number of decimals |
| Select the number of decimals to display |
Value display | 
| Display values in :
|
Prefix |
| Text is added before the value
|
Suffix |
| Text is added after the value |
| Zero value |
| Select value you want to show for zero. Options available are |
Negative value |
| Define how you want to display negative values. Options available are, |
Reverse signs | 
| Activate the option to multiply by |
1000 separator |
| Activate the option if you want to display a thousands separator. |
