# Named Query, Power table, Row color based off column value

**URL:** <https://forum.inductiveautomation.com/t/named-query-power-table-row-color-based-off-column-value/20779>\
**Category:** Ignition\
**Created:** [November 12, 2018, 7:36pm UTC](https://forum.inductiveautomation.com/t/named-query-power-table-row-color-based-off-column-value/20779 "2018-11-12T19:36:18Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![bpreston](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\
**Post date:** [November 12, 2018, 7:46pm UTC](https://forum.inductiveautomation.com/t/named-query-power-table-row-color-based-off-column-value/20779/2 "2018-11-12T19:46:30Z")

</div>

To do that you would use the component scripting for the power table. The extension function configureCell. You would want to check for the value using something like:

```auto
 val = self.data.getValueAt(rowIndex,"column title")

 if val >= 0 and val <=90:
 	return{'background': 'red'}
 if val >= 91 and val <=120 :
 	return{'background': 'yellow'}

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/named-query-power-table-row-color-based-off-column-value/20779)._