Is there a way to conditionally change the background or foreground color of a datasheet row or column? For example if I list scheduled job information in a datasheet, for the jobs that are past due, I want to show them as red, for the jobs that need assignment within the hour I want them yellow, and all the rest should be green.
I can't find a control or method that lets me change these properties at the row level. I know I can purchase third party apps like Spread.vbx from FarPoint to do this, but I don't want to spend any money.
Any tips or techniques are greatly appreciated. Thanks