Print Page | Close Window

Conditional Format Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22303 Printed Date: 26 Apr 2024 at 4:45am Topic: Conditional Format Posted By: NCGOV Subject: Conditional Format Date Posted: 05 May 2017 at 10:19am I want to make the font RED for a field based on 2 sets of conditions. Right click on the field Format Field Font Tab Color X-2 If {field.priority} = "P" and {field.secsdi2ar} > 420 then crRed else if {field.priority} ="1" and {field.secsdi2ar} > 660 then crRed else crBlack A formula that will work - this one does not. I am sure it is something simple but I just cannot figure it out. Replies: Posted By: DBlank Date Posted: 08 May 2017 at 2:32am the formula looks valid. If you have any nulls in the results then you would need to make sure that the formula is set to use default values for nulls.

Print Page | Close Window