.
...
Setting Up the Template
Getting Started
In this tutorial [tutorial ExcelTemplate|] is being used to populate data and [ExcelApplication|] is being used to format the data. This part of the tutorial will make use of data marker modifiers.
| Note |
|---|
This example assumes an understanding of ExcelTemplate. If you are not familiar with how to set up an Excel template with data markers, please go through the Simple Expense Summary first. |
...
The optional modifier allows that data marker to be ignored on data binding. If you have a column that may be empty, the optional modifier allows you to bind the data set regardless. It is used like this:
Conditional Formatting
[ExcelTemplate|] will persist conditional formatting in a template. In this tutorial, conditional formatting is applied to the "Other" table. It sets negative numbers to be red and bold. 
...