# Conditional Formatting Table in Perspective

**URL:** <https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215>\
**Category:** Ignition Early Access\
**Created:** [April 17, 2019, 6:45pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215 "2019-04-17T18:45:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tcurtis](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tcurtis/32/8653_2.png) [@tcurtis](https://forum.inductiveautomation.com/u/tcurtis)\
**Post date:** [April 17, 2019, 6:45pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215/1 "2019-04-17T18:45:18Z")

</div>

Is it possible to do conditional formatting of rows in a table in Perspective based on a value within that table? So if I have a threshold for a table and two rows are below that threshold then they are highlighted red?

---

<div class="post-metadata">

**Author:** ![tcurtis](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tcurtis/32/8653_2.png) [@tcurtis](https://forum.inductiveautomation.com/u/tcurtis)\
**Post date:** [April 19, 2019, 1:29pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215/2 "2019-04-19T13:29:06Z")

</div>

Does the silence means no???

---

<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:** [April 19, 2019, 3:05pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215/3 "2019-04-19T15:05:49Z")

</div>

As far as I know, there’s no way to do ‘conditional formatting’ the way you would do this in something like Excel. What you’ll have to do is manipulate whatever method you’re using to populate your `data` array (ie, add a transform) so that each cell that meets the criteria you define gets a `style` object applied.

---

<div class="post-metadata">

**Author:** ![tcurtis](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tcurtis/32/8653_2.png) [@tcurtis](https://forum.inductiveautomation.com/u/tcurtis)\
**Post date:** [April 19, 2019, 3:18pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215/4 "2019-04-19T15:18:16Z")

</div>

I am actually wanting to highlight a whole row based on one field. If the row has a field where the column ‘Active’ is TRUE then the row is green. Are there any examples of such a transform that you can think of?

---

<div class="post-metadata">

**Author:** ![ynejati](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ynejati/32/6093_2.png) [@ynejati](https://forum.inductiveautomation.com/u/ynejati)\
**Post date:** [April 26, 2019, 8:47pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-table-in-perspective/24215/5 "2019-04-26T20:47:41Z")

</div>

Hi,

As of this week, you can apply styles to individual rows of the table component. See my most recent post here: [[Feedback] NEW Perspective Table](http://forum.inductiveautomation.com/t/feedback-new-perspective-table/21199/30)

It seems as though you are rolling your own Alarm Status Table of sorts. Just to let you know, the Perspective Alarm Status Table is on the way, and should be available in the nightly build as soon as next week.

-Yousuf