Is it possible to set a cell level conditional value based on the value being null? We have been unable to find the setting. Thanks!

make a calculated field that aggregates it. If it’s null then it will be zero. count(date_field) Then conditionally format the field based on the new field.

You need to go to the field values. Select format and more formatting options. [image] [image] Then you can edit the Null values

Right but I’d actually like conditional COLORS based on a null value. It’s usually asking me for an exact match or numbers between x y z and I want the cell to turn Red if it’s null.

Conditional formatting can only be applied based on the Values. If it’s null the count of it will be zero. So you can check if the count is zero and if so return red as a background color. [image]

How would that work for a null “Date Type” I’d like the cell to be “Red” if there’s the column has a value of “null” (which I have changed the display for so that it says “no upcoming visit scheduled” [Screen Shot 2022-12-09 at 5.23.42 PM]

Similarly for a “Text” field where there’s no aggregation?

Conditional formatting on null values

Q&A

Max December 2, 2022, 7:09pm 2

You need to go to the field values. Select format and more formatting options.

Then you can edit the Null values

Quick Sight Pivot table empty rows question

Topic		Replies	Views
Conditional Formatting Pivot Table Values - "Redacted" Text? Q&A analysis , formatting , quick-sight	3	643	September 26, 2022
Conditional formatting based on dynamic cell value Q&A formulas , analysis , quick-sight	1	1625	July 17, 2022
Conditional formatting (color a row) based on values from another column in the dataset Q&A analysis , formatting , quick-sight	1	1138	May 8, 2023
Quick sight formula required Q&A developer , error , quick-sight	10	80	April 24, 2025
Conditional table formatting using dynamic value Q&A analysis , formatting , quick-sight	1	769	March 31, 2022

Conditional formatting on null values

Related topics