>How can I change row Dynamicbackcolor depending on the data in table. I want to be able to have 12 different colors all depending on the data. The parameter in the Dynamicbackcolor does not permit more than 256chars and has to be reevaluated for each line. ??
You've a couple of choices
- You can create UDF or method that would return RGB() value and use it in the Dynamicbackcolor.
- You can create lookup table with values and colors, set relation to it and use RGB() color values in the Dynamicbackcolor
--sb--