---
title: "Advanced column styles"
canonical: "https://support.appfire.com/space/atdc/2911505913/Advanced%20column%20styles"
format: markdown
---
> Macro (aura-html)

<span style="color: #000000">This page provides an example to make user defined styles persist for columns. For this example, let's consider the</span> [Monthly Temperatures Table](https://appfire.atlassian.net/wiki/spaces/atdc/pages/2911502874)<span style="color: #000000">, for which you want to set background colors and borders of various columns, and auto-number all the rows.</span>

### <span style="color: #000000">Select this macro</span>

|  |  |
| --- | --- |
| ***<span style="color: #000000">Macro name</span>*** | *<span style="color: #000000">Table Plus</span>* |
| ***<span style="color: #000000">Macro syntax</span>*** | *<span style="color: #000000">{table-plus}</span>* |

### <span style="color: #000000">Define these parameters/values</span>

|  |  |
| --- | --- |
| ***<span style="color: #000000">Column settings > Formatting > Column Styles (1</span>***<br>***<span style="color: #000000">2</span>***<br>***<span style="color: #000000">3</span>***<br>***<span style="color: #000000">4)</span>*** | *<span style="color: #000000">background:lightgrey; padding:15px;</span>*<br>*<span style="color: #000000">background:lightblue; color:teal</span>*<br>*<span style="color: #000000">background:lightyellow; border: 3px dotted green;</span>*<br>*<span style="color: #000000">2</span>* |
| ***<span style="color: #000000">Column settings > Numbering & Totaling > Insert auto number column</span>*** | <span style="color: #000000">On</span> |
| ***<span style="color: #000000">Column settings > Numbering & Totaling > Auto number column styles</span>*** | *<span style="color: #000000">border: 5px solid #c1c7d0;</span>* |
| ***<span style="color: #000000">Column settings > Numbering & Totaling > Apply Column styles to data column cells</span>*** | <span style="color: #000000">On</span> |

> ⚠️ <span style="color: #000000">Observe that column 1 styling is repeated in column 4, but, value 2 is used instead of 1. This is because </span>*<span style="color: #000000">Insert auto number column </span>*<span style="color: #000000">in </span>**<span style="color: #000000">On</span>**<span style="color: #000000">.</span>

### <span style="color: #000000">Screenshots</span>

![Advanced Tables for Confluence Data Center column styles configuration panel](media://42ebb4d7-4253-4c9b-ade7-2eda33dbb820)

![Advanced Tables for Confluence Data Center column formatting options interface](media://0e915335-d464-4632-b2d0-6a1a6ff483d8)

### Example result

<span style="color: #000000">When the </span>*<span style="color: #000000">Apply Column styles to data column cells</span>*<span style="color: #000000"> is off, certain styles like the padding and the text color are not applied as shown:</span>

![Table before applying advanced column styles in Advanced Tables for Confluence Data Center](media://b3e55690-de4e-493d-980b-34a65b09249f)

<span style="color: #000000">When the </span>*<span style="color: #000000">Apply Column styles to data column cells</span>*<span style="color: #000000"> is toggled on, the table is displayed with all the specified styles as shown:</span>

![Table after applying advanced column styles in Advanced Tables for Confluence Data Center](media://aa71b948-e000-450e-a069-f0606e403d94)