>This only works if the table is in record number order - in his case it's not.

Yep, my bad. This should work:

this.setall('DynamicBackColor', 'iif(mod(this.activerow, 2) = 1, rgb(255,0,0), rgb(0,255,0))', 'Column')