I'm interested in this as well.
I found a posting today out on the Symantec Forums. It is called:
How to make PAST DUE Incidents change color
In this posting, John Doyle did post some updated code to color code the columns and such. It is much easier to follow and use because now you can use color names rather than having to figure out the actual numeric code. Excellent work John.
The code however, doesn't address how to target the Due column specifically. I was able to come up with this:
Code:
sb.AppendFormat("else if({0}.Cell(0, 0, nPos) == '{1}') {{ {2}",grid,TryString("Due"),vbCrLf)
sb.AppendFormat(" if({0}.Cell(0, nCol, nPos) == '{1}') {2}",grid,TryString("5/1/2008 12:00:00 AM"),vbCrLf)
sb.AppendFormat(" {{ {0}.Cell(7, nCol, nPos) = {1}; {0}.Cell(6, nCol, nPos) = {2}; {0}.Cell(13, nCol, nPos) = true;}}}} {3}",grid,ColorTranslator.ToWin32(Color.Black),ColorTranslator.ToWin32(Color.Magenta),vbCrLf)
This works perfectly against the incidents that have this specific due date and time. Of course we would want this to be automatic. I know in my case I would like to perhaps use the traffic light approach, where Green = due 1 day out, Yellow = due today, and Red = past due.
The ultimate question is how to do that.
