# Power Table Cell Colour

**URL:** <https://forum.inductiveautomation.com/t/power-table-cell-colour/33191>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [March 18, 2020, 4:42am UTC](https://forum.inductiveautomation.com/t/power-table-cell-colour/33191 "2020-03-18T04:42:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shanmukharao.C](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shanmukharao.c/32/29664_2.png) [@Shanmukharao.C](https://forum.inductiveautomation.com/u/Shanmukharao.C)\
**Post date:** [March 18, 2020, 4:42am UTC](https://forum.inductiveautomation.com/t/power-table-cell-colour/33191/1 "2020-03-18T04:42:14Z")

</div>

Hi Everyone!, i trying to color a cell in Power Table Manually, like how will assign cell background colour in MS Excel. Guys Please Help Me in this.  
 ![cell%20clour](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/ecc9373e942122ecf9ef26225971804889dfd397.png)

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [March 18, 2020, 7:04am UTC](https://forum.inductiveautomation.com/t/power-table-cell-colour/33191/2 "2020-03-18T07:04:27Z")

</div>

For power table, you need to do the configuration by scripting.

Right click on the power table, go to scripting, and enable the configureCell script. It has a default demo script for setting the background.

 ![afbeelding](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/43b66352d017d54ca3a7abc7433a2f643165bcd8.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 18, 2020, 3:52pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-colour/33191/3 "2020-03-18T15:52:38Z")

</div>

As for per-cell configuration like Excel does with cell formatting, you’ll need to:

1. Make some kind of interface for color selection/font/etc - whatever attributes you (are able to) and want to customize about cell rendering.  
See this thread: [Designer Color Chooser vs Runtime Color Chooser](http://forum.inductiveautomation.com/t/designer-color-chooser-vs-runtime-color-chooser/32505/9)  
for an example of a power-table based color picker that you could use.
2. Store the user’s preferences, deciding how to do so. Most likely, you’ll need to keep a second dataset with matching row/column counts as a custom property somewhere, and store the cell-specific information in each cell.
3. In `configureCell`, as @Sanderd17 mentioned, you’ll need to actually retrieve the cell rendering information, parse it in some way, and then apply it to each individual cell.

All in all, this is a pretty significant amount of work; it’s doable, but would require a lot of effort. There’s also many aspects of power tables that basically can’t be customized (per-cell borders, for instance) without a _great_ degree of effort.