BusinessObjects Board

Crosstab Conditional Color

Does anyone have a formula to conditionally format cross-tab row colors based on the row text?


ncgov (BOB member since 2018-10-17)

I figured it out!

Format field
Insert formula in the background color

If GridRowColumnValue (“Field”) like “H*” then rgb (221,238,255)
else if GridRowColumnValue (“Field”) like “A” then rgb (255,204,204)
else if GridRowColumnValue (“Field”) like “R*” then rgb (204,255,230)
else crNocolor


ncgov (BOB member since 2018-10-17)