# Method to customize row or cell background color when using a dataset on perspective table

**URL:** <https://forum.inductiveautomation.com/t/method-to-customize-row-or-cell-background-color-when-using-a-dataset-on-perspective-table/86871>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [March 6, 2024, 4:32am UTC](https://forum.inductiveautomation.com/t/method-to-customize-row-or-cell-background-color-when-using-a-dataset-on-perspective-table/86871 "2024-03-06T04:32:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ltoscano](https://avatars.discourse-cdn.com/v4/letter/l/3be4f8/32.png) [@ltoscano](https://forum.inductiveautomation.com/u/ltoscano)\
**Post date:** [March 6, 2024, 4:32am UTC](https://forum.inductiveautomation.com/t/method-to-customize-row-or-cell-background-color-when-using-a-dataset-on-perspective-table/86871/1 "2024-03-06T04:32:56Z")

</div>

Hello Everyone,

Fairly new to perspective still. I have a table where the data source is fixed - I.E. I manually added an array object to the data prop. Since there's only 8 rows it's a pretty straightforward thing, and I can easily change the background color of each cell in a row based on some external tag. All works great.

I have another table where I want to mimic that behavior but it's a much bigger table and so I point the data property to a query to populate the data. But now I don't see an easy way to dynamically alter the rows/cells. What am I missing?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![amy.sudibyo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amy.sudibyo/32/38659_2.png) [@amy.sudibyo](https://forum.inductiveautomation.com/u/amy.sudibyo)\
**Post date:** [March 6, 2024, 6:11am UTC](https://forum.inductiveautomation.com/t/method-to-customize-row-or-cell-background-color-when-using-a-dataset-on-perspective-table/86871/2 "2024-03-06T06:11:47Z")

</div>

You will need to add a script transform to recreate your table data in a JSON structure with style objects included.

There are a couple of examples in the [user manual](https://docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table)