2 Replies Latest reply on Jul 26, 2011 10:04 AM by Tbear

    Conditional Formatting help request

    Tbear

      Title

      Conditional Formatting help request

      Post

      On my "Event Detail" layout I have a field from called 'Total Invoices Sent', and another field called 'Registration Admi'.

      I want to conditionally format the 'Total Invoices Sent' field box to read "By Other" whenever the 'Registration Admin' field reads "Local" which is one selection from it's value list. 

      I've tried everything I can think of but NOTHING ever happens one way or the other. 

        • 1. Re: Conditional Formatting help request
          philmodjunk

          I wouldn't use a conditional format to do this. You'd need one setting to hide the contents of the field and another to reveal the layout text "By Other".

          Use a calculation field:

          If ( Registration Admin = "Local" ; "By Other" ; Total Invoices Sent )

          Place this field on your layout instead of Total Invoices Sent.

          • 2. Re: Conditional Formatting help request
            Tbear

            I mostly understand what you mean about what I'd have to do to use Conditional Formatting for this although that lack of simplicity seems out of character with the rest of what I understand about FM 11 so far.

            Nevertheless I have used your "fix" and found it quite satisfactory - thank you very much once again! (speaking of invoices, you should probably be sending me one!)