Conditionally Color Rows

You can learn to edit the FORMAT string directly. This is made much easier with a tool that splits (parses) the FORMAT into one Column per Line. I made one and Mark wrote an IDE plug-in.

E.g. you just have to add an ‘’ to each column for Color or a ‘Y’ for style. Seeing the Format split out makes it easy to see which columns are missing the '’ / ‘Y’.

 FORMAT('[' &|
          '27R(2)|M~Cust.~C(0)@n_6@'                         &|
          '41R(4)|M~Meter~C(0)@n_9@'                         &|
          '4C|M~Port~@n1@'                                   &|
                         '](85)|M~I.D. Numbers~'             &|
        '['                                                  &|
          '38R(2)|M~Previous~C(0)@d1@'                       &|
          '47R(2)|M~Current~C(0)@d1@'                        &|
                                    '](76)|M~Reading Dates~' &|
        '['                                                  &|
          '41R(2)|M~Current~C(0)@n_9@'                       &|
          '41R(2)|M~Prior~C(0)@n_9@'                         &|
          '39R(2)|M~Usage~C(0)@n-9@'                         &|
          '22C|M~Meter~@s1@'                                 &|
          '21C|M~Read~@s1@'                                  &|
          '4C|M~Final~@s1@'                                  &|
                          '](224)|M~Readings~'               ), |