I have a subform that returns a bunch of records. Each of the records returned has a LANE_ID, so in this example, there are 10 records returned, 5 with LANE_ID = 11111and 5 with LANE_ID = 22222. Is it possible to alternate the backgrond color for each of these groupings?

I have found examples of how to change the color of alternate rows, but I can't find anything that would tell me if what I want to do is possible.

This can probably be done, but it will not be easy. You see how to do the alternate rows so maybe you can adapt that approach. I have not seen done what you want to do so I have no suggestions on how to solve it....

Jack

Sounds like what you are trying to do is very similar to a little conundrum I had the other day.
My solution is at the bottom if the follwoing thread...

Conditional formatting thread

Hope this helps

Dan

You can use conditional formatting to set the background of all records with LANE_ID = 22222 to a particular color.
If you only want 2 colors then you just need a single conditional format statement, but you first have to find the list of LANE_IDs which need their colors changing.

The alternate row coloring trick (using bookmarks) will not help you