6 Replies Latest reply: Aug 21, 2012 5:39 AM by Sunil Chauhan RSS

    Alternating coloured stripes to represent groups of repeating numbers

      Hello i'm trying to visually identify groups of repeating numbers in a flat table by alternating the colour each time a number changes like so:-

       

      10001111

      10001111

      10001111

      12345555

      24681111

      24681111

      10002222

       

       

      ive tried to use this script under 'change background colour' in dimension tab:-

       

      =if(mod(BP,2),rgb(135,206,255),rgb(84,255,159) this doesnt quite work, seems to have a mind of its own, I would like to achieve this each time a number changes.

       

      Thanks,

       

      Paul.