Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    4

    Unanswered: Compare a total to + or - $5.00

    I have a report I created and I want to be able to verify a grand total to a total in our database. I need to make sure that if the amount is off by +- $5.00, that the row is in red.

    I figured it would be a if then statement but I'm not sure what function could do this. I'm new to Crystal, so any help would be great.

    Thanks,

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Highlight all the objects that you want to change the colour off. Then right click . This will open the Format Editor. Go to Font and then Click on the Conditional formatting button next to the Color.

    Then enter your conditional statement
    If Sum (Field) <> 5 Then Red

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •