I have no idea. But the idea I do have is perhaps to start with Leban's conditional formatting sample. Try to find something in there that might lead you down the right path. Perhaps a worst case workaround is to establish the case of the last record and input that as the condition for that row to change colors.
-dK