3 Replies Latest reply on Nov 2, 2011 10:12 AM by philmodjunk

    Help with conditional format using > and <

    kilbot

      Title

      Help with conditional format using > and <

      Post

      having trouble with the greater than or less than in this conditional to change field fill color.

       

      ScreenHunter_01_Nov._02_09.00.jpg

        • 1. Re: Help with conditional format using > and <
          philmodjunk

          IsEmpty ( Evaluation::Date_closed_manager ) and
            ( ( evaluation::date current - Evaluation::contract_date_received )  ≥ 3 ) and
            ( ( evaluation::date current - Evaluation::contract_date_received ) ≤ 6 )

          You might use the let function to simplify this:

          let ( days = evaluation::date current - Evaluation::contract_date_received ;
                          IsEmpty ( Evaluation::Date_closed_manager ) and ( days   ≥ 3 ) and ( days ≤ 6 )
               ) // end let

          • 2. Re: Help with conditional format using > and <
            kilbot

            question,

            I have another conditional on this field stating if it is equal to or greater than 7 to turn red. However the one above works to turn yellow but the second one to turn it to red does not show at all. Where am I going wrong?

            • 3. Re: Help with conditional format using > and <
              philmodjunk

              I'd need to see those expressions.

              Conditional formats evaluate from the top of the list down, applying each change in turn. Thus, if both the "yellow" and "red" conditional format expressions evaluate as true, you get a "red" result as it is the last format to be applied to the layout object.