Conditional Formatting when breaching a number barrier first time.

[NickFaraday4]

Ok I have a summary report that groups a bunch of records in various sizes and have a summary count field to let me know how many records are in each grouping. Is there a way to set conditional formatting when I breach a total number of records ceiling, but only format the group at which the breach occurred?

So right now I have a field that shows a "running total" and I can set the conditional format to trip for all the records after a record number ceiling has been breached, but what I want to do is only highlight the group where the ceiling was passed not all groups after.

Any Ideas?

[comment]

Use the GetSummary() function.