10 Replies Latest reply on Nov 12, 2013 9:11 AM by Joshua Milligan

    Conditional Colouring based on Last Non Empty value

    sirajmandayippurath

      Hi All,

       

      I have been fiddling around with trying to get conditional formatting to work based on the last value of Actuals on the attached graph.

       

      Capture.JPG.jpg

      The logic is to compare the last bar on the graph to the forecast value (line) and then colour 'ALL' the bars based on the comparison result. i.e., if Actuals is less than Forecast for the last month, then all the bars should be Red and if the Actuals is greater than Forecast for the last month, then all the bars should be Green. My challenge, as you can see, is that I am not able to focus the conditionality on just the last month.

       

      I have attached the packaged workbook for anyone who would fancy playing about.

       

      Many thanks in advance!

       

      Cheers

      Siraj