# Conditional Formatting in Reporting Table

**URL:** <https://forum.inductiveautomation.com/t/conditional-formatting-in-reporting-table/20406>\
**Category:** Ignition\
**Created:** [October 26, 2018, 7:00pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-in-reporting-table/20406 "2018-10-26T19:00:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ClayBuysse](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@ClayBuysse](https://forum.inductiveautomation.com/u/ClayBuysse)\
**Post date:** [October 26, 2018, 7:00pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-in-reporting-table/20406/1 "2018-10-26T19:00:51Z")

</div>

I have created a report in the Report Designer (Ignition version 7.9) and I would like to have the color of the text in one of the fields change based on the value in that field. Basically, I’d like to turn the text red if the value is below a threshold. I see no easy way to do this. Am I going to have to dig into scripting on the report?

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [October 26, 2018, 7:09pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-in-reporting-table/20406/2 "2018-10-26T19:09:19Z")

</div>

If you click on the field and look at its properties, you will see ‘Text Color’. Right-click this field and select ‘Use dynamic data key’.

Now you can enter an expression for the colour of the field e.g. `input>2?"red":"blue"`. Look [here](https://docs.inductiveautomation.com/display/DOC79/Keychain+Expressions) in the manual.

---

<div class="post-metadata">

**Author:** ![ClayBuysse](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@ClayBuysse](https://forum.inductiveautomation.com/u/ClayBuysse)\
**Post date:** [October 26, 2018, 8:07pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-in-reporting-table/20406/3 "2018-10-26T20:07:03Z")

</div>

Perfect! That did the trick.

Thanks
