Hopefully this is a quick one for you experts out there. I have a grid that has several fields that have their color set in a complex way that I don't understand, but it works. I have a need to override the colors of certain columns based on an overdue date. I have code that works BUT it always sets makes the color either red or white and I need it to make it red if a condition is met and NOT change it from what it is if the condition is not met.

Here is my code that changes it to Red - But also can change it to white:

this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),RGB(255,255,255))

Here is the code that I thougth would work but doesn't:

this.column4.DynamicBackColor = 'iif(duedate < DATE(),RGB(255,50,50),this.column4.DynamicBackColor)'

Here is something else that gives me a variable undefined:

IF duedate < DATE()
this.column4.DynamicBackColor = RGB(255,50,50)
ENDIF

Any help is appreciated.

Thanks,

Randy