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

    Conditional formatting




      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.



        • 1. Re: Conditional formatting
          Simon Ma Employee



          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