Does anyone have a formula to conditionally format cross-tab row colors based on the row text?
ncgov (BOB member since 2018-10-17)
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)