# Conditional formatting of NULLs in report table

**URL:** <https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [November 15, 2023, 6:06pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943 "2023-11-15T18:06:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 15, 2023, 6:06pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943/1 "2023-11-15T18:06:15Z")

</div>

My named query returns recipe parameters with (valid) NULLs where there is no table entry. These get converted to `<N/A>` by the Report module table component. I'd like to render all the `<N/A>`s in light grey to reduce the visual clutter (while keeping QA happy by not having empty cells).

![Report table conditional formatting](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/7/e7994e8d68567f599c368de667d356ef8ea2e547.png)

I'm reading through the docs [Keychain Expressions](https://docs.inductiveautomation.com/display/DOC79/Keychain+Expressions) section but can't figure out the syntax to use in the cell's Text Color property. I've tried various variations of,  
`@Parm1@?"red":"blue"`  
`@Parm1?"red":"blue"`  
`@Parm1==None?"red":"blue"`  
`@Parm1=='<N/A>'?"red":"blue"`  
(Red and blue are just to make it very obvious whether or not anything is happening.)

Any ideas?

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [November 15, 2023, 6:10pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943/2 "2023-11-15T18:10:36Z")

</div>

It's been a minute since I've done reporting.

It says in the property inspector @ isn't needed. Perhaps try without?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 15, 2023, 6:15pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943/3 "2023-11-15T18:15:12Z")

</div>

> [@jlandwerlen](#):
>
> @ isn't needed. Perhaps try without?

Bingo!  
`Parm1?"red":"blue"`  
works.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 15, 2023, 6:40pm UTC](https://forum.inductiveautomation.com/t/conditional-formatting-of-nulls-in-report-table/81943/4 "2023-11-15T18:40:58Z")

</div>

Minor follow-up: do you know what set of colors the report supports? It doesn't support `#123456` format and I didn't get a result from `color(180, 180, 180)` or Color(). Is it using a Java format?

* * *

I found it. I needed to quote the color.  
`Parm1 ? "blue": "lightGray"`