How to format using Cell Settings cells that are null?

FIRST CREATED ON 17 Jun 2025 I AUTHOR Emma Camacho

To format the cells that are null in the following example:

Use Cell Settings to format the cells:

Pattern Expression: if (String.IsNullOrEmpty([CellValue]),1,[KeepOriginal] )

Color Expression: if (String.IsNullOrEmpty([CellValue]),Rgb(255,0, 0),[KeepOriginal] )

To get the following table in Powerpoint

For more information, see Mail & Deploy Advanced: How to use cell formatting to create customized tables in Mail & Deploy.

Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.

• Related Articles

• How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?

  FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...

• Creating Custom Calculations in Excel Reports Using Mail & Deploy?

  You want to create an Excel report using Mail & Deploy. Specifically, you have a table spanning columns A to K and need Column G to display the result of Column I × Column B, instead of using the result directly from the Qlik app. Solution: While the ...

• How to use page breaks in Excel when using a repeater (same sheet)? (2/2)

  FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters, this time the Debug version of the report. The definitions are the same as the example in How to use page breaks in Excel ...

• How to use page breaks in Excel when using a repeater (same sheet)? (1/2)

  FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters. The output should look like this: Each page will have 4 tables and the last one might have less. The template looks like ...

• How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?

  FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case: Display ...