> For the complete documentation index, see [llms.txt](https://knowledgebase.qommentary.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.qommentary.com/qommentary-pivot-table/setting-up-your-table/adding-color-to-cells.md).

# Adding color to cells

Color is a powerful visual indicator which can help identify change or trends over time. The *Qommentary Pivot Table* allows you to add custom background and text colour to dimensions and measures.

To add color to your cells, follow these steps:&#x20;

1\. Click on **Edit sheet** button

2\. Expand the dimension/measure properties

3\. Scroll down to the **Background color expression** property and enter a value or expression

<div align="left"><img src="/files/obgB3UObS4LHKkPDvppN" alt=""></div>

4\. Scroll down to the **Text color expression** property and enter a value or expression

<div align="left"><img src="/files/FveZlh5sx6FqY8MuzQHY" alt=""></div>

The pivot table will now evaluate each cell expression and display the relevant colors

![](/files/PEuxsqWf7jVaEH7yHrdq)
