Hi All,

Another issue with DynamicBackColor, where this time I want to highlight only the "Total" row after the calcuation has been made. To begin, this is what I am attempting to do.

Items | Jan | Feb | Mar | ...
Apple | 001 | 000 | 000 | ...
Grape | 002 | 003 | 007 | ...
Pear | 010 | 115 | 125 | ...
Total | 013 | 118 | 132 | ... <- Background X color with Y color text

I have this code in my Grid1.Init()

This.SetAll("DynamicBackColor","IIF(ALLTRIM(Fruit.Items)='Total',RGB(255,123,100),RGB(255,0,125)","COLUMN")

When the program first run, Fruit Cursor was empty and it gets populated based on the date range that the user assigned. During the process, I zapped the Fruit table and append it with Fruit_Temp table (like below).

SET SAFETY OFF
ZAP IN 'Fruit'
SET SAFETY ON
SELECT Fruit
Append FROM (DBF("Fruit_Temp"))

ThisForm.Grid1.Refresh()

I did not get any error messages from VFP, and BackColor for "Total" in grid1 has not been changed. Any Ideas, Solutions or suggestions.

TIA