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 format table cells using Cell Settings (some examples) ?
FIRST CREATED ON 16 Dec 2026 I AUTHOR Emma Camacho Stripped Table if ( [IsEvenRowNumber], Rgb(192, 192, 192), Rgb(255, 255, 255)) Highlight Value if ( [Table].GetCellValue([RowNumber],1) = [ReportParameter].[Customer], Rgb(255, 128, 64),Rgb(0, 0, 0)) ...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 ...How to create a Word report using PowerBI as a data source in Mail & Deploy using SQL queries (with example)?
FIRST CREATED ON 11 Aug 2025 I AUTHOR Emma Camacho Creating an Word report using a PowerBI 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 Design a ...How to create a Word report using PowerBI as a data source in Mail & Deploy using DAX queries (with example)?
FIRST CREATED ON 11 Aug 2025 I AUTHOR Emma Camacho Creating an Word report using a PowerBI 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 Design a ...How to use page breaks in Excel when using a repeater (same sheet)? (2/2)
FIRST CREATED ON 24 Jun 2025 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 ...