Crosstab Conditional Color

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: NCGOV — 20 Feb 2019 at 3:17am

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

Edited by NCGOV - 20 Feb 2019 at 3:20am

Posted By: NCGOV — 20 Feb 2019 at 9:04am

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