>Hi Hilmar,
>
>Thanks for quick response, but could you please provide an example for the single column.
>
>Thanks
Disable the .SetAll() command.
Select a single column in the Property Sheet, search for the DynamicBackColor property, and set it to whatever you please. Copying from your example, it might be:
IIF(ALLTRIM(Fruit.Items)='Total',RGB(255,123,100),RGB(255,0,125)
Without outside quotation marks - I think. Try with and without them.
This is for debugging purposes only; .SetAll() does seem to be the appropriate way to go, if you want to highlight the entire column.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)