# Highlighting Specific Table Values

**URL:** <https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063>\
**Category:** Ignition\
**Created:** [September 16, 2014, 2:36pm UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063 "2014-09-16T14:36:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cthorpe](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@cthorpe](https://forum.inductiveautomation.com/u/cthorpe)\
**Post date:** [September 16, 2014, 2:36pm UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063/1 "2014-09-16T14:36:33Z")

</div>

Ignition 7.6.6  
Windows

I am having some difficulty with one of my Tables. We use this table to review Quality data to determine if material is good/bad in a fast paced environment. That being said I need a quick visual check so that they can pull up their data and at a glance see if any of the data is out of our specified range ie. Red Text/Bold.

so in their table, anything that is out of a range of say .050-.054 it will be red bold Text.

Please forgive me as this is the first post I have made to the forum.

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [September 16, 2014, 3:30pm UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063/2 "2014-09-16T15:30:33Z")

</div>

If you get your data from a database you can try something like this.

`SELECT val1, CASE 
				WHEN val1 BETWEEN 0.050 AND 0.054 THEN 0 ELSE 1 
			 END AS 'outofrange'
FROM mytable
`

On the table, add a background mapping off the outofrange column.  
You can change the font, foreground etc in a similar way.  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8e8f05be3dc9e54717863e660efe2b04c842a22a.png)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f2048181540e7b18f36ed07e9c8973e331a9f3a0.png)

---

<div class="post-metadata">

**Author:** ![cthorpe](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@cthorpe](https://forum.inductiveautomation.com/u/cthorpe)\
**Post date:** [September 16, 2014, 4:44pm UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063/3 "2014-09-16T16:44:27Z")

</div>

This is a big help however (my fault for not specifying) they are reviewing 28 columns of data, 21 of these need the mapping for the out of range color code. By your response would I not have to make 1 out of range column for each of the 21 columns under review, other wise if one was out of spec the entire row would follow the out of range color code? 😕

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [September 16, 2014, 5:38pm UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063/4 "2014-09-16T17:38:29Z")

</div>

You can use html to format the table.

`SELECT CASE 
		WHEN val1 BETWEEN 0.050 AND 0.054 THEN Val1 ELSE CONCAT('<html><b><font color="red">',Val1,'</font></b>') 
		END AS 'Val1',
		CASE 
		WHEN val2 BETWEEN 3 AND 5 THEN Val2 ELSE CONCAT('<html><b><font color="blue">',Val2,'</font></b>') 
		END AS 'Val2'		
FROM mytable`  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/62d1f84189f13f231940e165e016b3fda079cbac.png)

---

<div class="post-metadata">

**Author:** ![james30](https://avatars.discourse-cdn.com/v4/letter/j/439d5e/32.png) [@james30](https://forum.inductiveautomation.com/u/james30)\
**Post date:** [September 17, 2014, 5:43am UTC](https://forum.inductiveautomation.com/t/highlighting-specific-table-values/9063/5 "2014-09-17T05:43:43Z")

</div>

attractive post made… ![:prayer:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e5a7e3b63facc151ea73e3b45db7bdb3d4bdc316.gif ":prayer:")