>Thanks a ton, Marcia, your code works fine!
>
>The error I was getting was "Expression is invalid.Use a valid expression for Dynamicbackcolor property". My code was in the init of the grid.
>
>A related issue I face, is that I would like to color code cells in the grid with different colours, to fulfill different criteria. What I observe is that the last dynamicbackcolor statement predominates over the previous ones, allowing only one criteria. I've tried using multiple IIF's, but with mixed results, besides, at times being extremely complicated?Any suggestions on how to do this?
You may look at message #
1003169 or message #
904351, there's the simplest trick described.