# Change specific row background on Perspective Table based upon int value in dataset

**URL:** <https://forum.inductiveautomation.com/t/change-specific-row-background-on-perspective-table-based-upon-int-value-in-dataset/36678>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 14, 2020, 12:31pm UTC](https://forum.inductiveautomation.com/t/change-specific-row-background-on-perspective-table-based-upon-int-value-in-dataset/36678 "2020-07-14T12:31:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [July 14, 2020, 12:40pm UTC](https://forum.inductiveautomation.com/t/change-specific-row-background-on-perspective-table-based-upon-int-value-in-dataset/36678/2 "2020-07-14T12:40:53Z")

</div>

I think what's happening with your expression is that your evaluating the first row of the dataset; in your screenshot its \>=95 therefore all rows will be green.

You can achieve what you want by reading this post:

> [@\[Feedback\] NEW Perspective Table](http://forum.inductiveautomation.com/t/feedback-new-perspective-table/21199/48):
>
> For anyone wondering how they might be able to add custom row styles (and configuration) based upon a rows value derived from a dataset. You’ll need to create a transform on the bound dataset using a script like this example: output\_json = [] style\_orange = {"backgroundColor": "#F7901D"} style\_green = {"backgroundColor": "#00AA00"} for row in range(value.getRowCount()): row\_object = {} row\_value = {} row\_style = {} for col in r…

---

_[View the full topic](https://forum.inductiveautomation.com/t/change-specific-row-background-on-perspective-table-based-upon-int-value-in-dataset/36678)._
