1 Reply Latest reply on Aug 16, 2017 1:53 AM by Vasil Petkov

    Conditional Formating

    Tracey Stone

      I am trying to highlight a cell Yellow if the order number has an ORDER_LINE_STATUS = "AWAITING SHIPPING". Not sure how to do this??


      Thanks Tracey

        • 1. Re: Conditional Formating
          Vasil Petkov

          Hi Tracey,


          There is not easy way of doing this if you want to keep the Status color coding. I am attaching a solution which leverages table calcs to come up with custom calculations which are then colored differently within the text mark editor. My solution will also only work i there is one possible ORDER_LINE_STATUS per cell.


          I have added some comments in the calcs but let me know if you have any questions.