Daniel, in the DynamicBackColor for a column use a function which takes the cell value as a parameter and returns a color value using the RGB() function. The function would have, for instance, a DO CASE which evaluates different value ranges and returns different RGB() values accordingly.
>Hi, All.
>
>I created a grid and I used DynamicBackColor & DynamicForeColor to highlight cells with data in them. So cells with data will have a different color than those without. How do I display more than two colors (background colors) to show a range of different colors for cells with different data?
>Does anyone know how to do this?
>Thanks in advance.
>
>Regards
>Daniel
>Singapore
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.