How to format table cells using Cell Settings (some examples) ?

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))
or
if ( InStr( [Table].GetCellValue([RowNumber],1), [ReportParameter].[Customer]) = 1, Rgb(255, 128, 64),Rgb(0, 0, 0))

Colored cell values
if ( [CellValue] >0, Rgb(0, 255, 0),Rgb(255, 128, 255) )

Pivot table with columns highlighted according to Year in a parameter
if ( [Table].GetCellValue(1,[ColumnNumber])=[ReportParameter].[Highlight Year], Rgb(192, 192, 192),Rgb(255, 255, 255) )

Totals in Bold
if ( [Table].GetCellValue(1,[ColumnNumber])="Totals", -1, 0 )



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.