datagrid row color based on cell value from API results

Widgets & Design

I have an API query that populates a data grid, I have organised it so the last row in the API query displays the totals.

I want to change the background colour of this one row based on the fact that the text in the first field of the row displays 'Total'.

What have you tried so far?

searched the comunity and google. The only thing i found was this

Did you check FlutterFlow's Documentation for this topic?

Yes