True db grid

[Taftheman]

Hi i have a grid with information showing, however within the records i have a total sum for each terms (school term), i need to show the totals in a different colour or make it stand out compared to to normal data, i am using a true db grid

how would i do this i though about looping through the table and where the caption of the record is like total then change the style background colour

any help appritiated

cheers