Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using Highlighing Expert based on a string value.

Attached is an example report that was not created by Crystal Reports.  I am working on re-creating it in Crystal Reports.

I am using Crystal Reports 2011.

I need to have only certain fields highlighted in yellow whose Serial No. starts with B.  How do I do that?


Keith Jackson


Hi Keith,

Right-click the field > Format Field > Border tab > click the formula button beside 'background' and use this code:

if {serialnumber} startswith 'B' then crYellow

else crNoColor


1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question