Print Page | Close Window

Crosstab Conditional Color

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22732
Printed Date: 25 Apr 2024 at 4:30am


Topic: Crosstab Conditional Color
Posted By: NCGOV
Subject: Crosstab Conditional Color
Date Posted: 20 Feb 2019 at 3:17am
Does anyone have a formula to conditionally format cross-tab row colors based on the row text?


Replies:
Posted By: NCGOV
Date Posted: 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


Print Page | Close Window