3 Replies Latest reply on Dec 29, 2016 3:31 PM by pmartin

    VBA color change based on condition

    pierpaolo

      good morning
      How can I in VBA to change color to a value if it exceeds the minimum of 100 for more than 30 minutes

        • Re: good morning
          pmartin

          Hi Pierpaolo,

           

          Is this for a ProcessBook display?

          If so, have you considered using a Multistate symbol?  You can set the multistate to use a performance equation such as:

          if TimeGT('sinusoid','*-30m','*',100) >= 1800 then 1 else 0

          which means "If sinusoid is greater than 100 for more than 1800 seconds in the last 30 minutes, return 1, else, return 0"