1 Reply Latest reply on Jun 13, 2013 4:42 AM by Simon Ma

    Conditional formatting

    elkum Apprentice

      Hi,

       

      Is there a possibility to configure conditional formatting in a report like in Excel?

       

      For example: I have a list of all devices with their last software scan date. Now i want that all devices with a last software scan date 30 days ago get highlighted automatically. So I can immediately see which devices were for example offline for a long time.

       

      Regards

        • 1. Re: Conditional formatting
          Simon Ma Employee

          Hi,

           

          Yes you can.

          You need to change the appearence of the field (text Color or Background Color) and instead of using a simple color, you can use a conditional expression.

           

          The expression should be something like : =IIF(DataDiff(Day,[your Date Field], Today) > 30, "Red" , "Black")

           

          Here an example :

          Sans titre.png

           

          Simon