5 Replies Latest reply on Oct 24, 2012 10:52 AM by MarkRiddle

    Conditional Formatting script help



      Conditional Formatting script help


           Ok, so I'm not a whiz at writing formulas for a conditional formatting, but I'm 99% of the way there.

           I have a script that is currently working, but I need to change it to add another condition.

           Here is my current formula, which is working but needs changing:

      (IsEmpty ( LATC  Registrations::Amount )  or IsEmpty ( LATC  Registrations::Check No. )) and IsEmpty ( LATC  Registrations::Partner Agency )

           Here's what I'm trying to change it to do:

           I'm tyring to have a field (payment amount) be red when the following conditions are met either singularly or together--doesn't matter:  "payment date" (checked field) is empty OR "partner agency" (checked field) is unchecked (empty) OR the "Has Credit" field is unchecked (empty). 

           Basically, if I have a person (entry) that DOES NOT meet any one of the above three conditions, the formatting on the "Payment Amount" field will be changed.

           Anybody got any help as to how I can modify or redo this script to do what I need?