Coloring rows to show groups of records

[Andrew Malcolmson]

I have a report where one or more rows belong to a group and I'd like
to color rows to help the reader easily see what rows belong together.

I'm trying to do this by writing a VBA function that tests for changes
in the column that distinguishes the groups. I then call this
function in a Conditional Formating condition to set the row color to
the alternate color from the row above. This seems to work but Excel
keeps crashing.

There must be a standard way to do this but I haven't found anything
yet, so any ideas appreciated.

 

[Frank Kabel]

Hi
how are your rows separated. Probably no need for VBA at all

 

[Andrew Malcolmson]

Hi
how are your rows separated. Probably no need for VBA at all

Each row describes an expenditure record. One column shows the name
of the department that did the spending. There could be any number of
rows/records for any one department.