# Column color for table component

**URL:** <https://forum.inductiveautomation.com/t/column-color-for-table-component/1373>\
**Category:** Archived Topics\
**Created:** [November 10, 2009, 1:52pm UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373 "2009-11-10T13:52:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 10, 2009, 1:52pm UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373/1 "2009-11-10T13:52:13Z")

</div>

I can see where we can set the background color for a row, but not a column. Will this be something in the works, or will I just have to satisfy myself with changing the color of the text? Or-- even more likely-- am I missing something again? 😆

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [November 11, 2009, 5:57pm UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373/2 "2009-11-11T17:57:21Z")

</div>

There is no Background Color Mapping for columns. However, if there are a set number of values for a given column, eg. Val1, Val2, Val3, you can set a Background Color Translation list in the Table Customizer. If the values have infinite possibilities you can set the background color of the column using HTML in the SQL query, eg:

`SELECT Col, CONCAT("<HTML><table width=1000 height=1000><tr><td bgcolor=red>", Col, "</td></tr></table>") as Col2 FROM Table` This is a MySQL example where you can embed HTML in the query. You can insert a table with a huge height and width (to guarantee that it is bigger than the cell) with a color of your choice. Hope this helps.

---

<div class="post-metadata">

**Author:** ![Brett\_Yeomans](https://avatars.discourse-cdn.com/v4/letter/b/35a633/32.png) [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\
**Post date:** [June 11, 2012, 10:30am UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373/3 "2012-06-11T10:30:34Z")

</div>

Any chance of explaining how to change the colour of a column. I have a fixed number of rows and want to highlight certain columns to indicate which are/are not editable.  
I see in the customiser Background Color List/Column but no documentation as to how to use these.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [June 11, 2012, 3:11pm UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373/4 "2012-06-11T15:11:10Z")

</div>

You can just add another column to the dataset that is the color state (must be an integer). You can hide the column from the user. In the customizer you can set the background color list column to the new column name you just created. So if it was called “colorState” make it the same. Then you can set the number to color translation. If you change the value of the color state column the background color will change.

By the way, this is an Ignition request so in the future post it to the Ignition Design Help forum.