The RowNo() returns the number of the row within a gruop of rows, but as soon as the group changes it resets to 1 again. Hence The above can be used if we want alternate coloring of rows in general, but for alternate coloring of grouped rows its not useful.
It works for the alternate coloring of rows, but if you see the desired output, i want all the rows with same 'project Number' to be of same color, i.e. the color should change for groups of rows alternativly. please refer to the image for better understanding,
can you please share the sample if its working for you?