Using Color groupings

[Andy-dont-use Pritchard]

I have a simple table that contains 2 columns. The first is time_raw ... which contains a number of decimal seconds ie 90.281. On this column i have a color grouping that uses the bottom/top rule types to highlight the smallest and largest values in the displayed data. All cool so far !

 

I have a requirement, to show the number of seconds in a more human intuitive way.... so instead of 90.281, it should say 1:30.281. Firstly i tried to find a say to get Spotfire to format this but failed (so let me know if there's a way !), so what i did was, as the source table is a Postgres view,I created a new string column (time_formatted) that showed the correctly formatted value.

 

Now i have the column, i'm trying to figure out how to set the color for the formatted data. I've done colorization before, where i could say if column A = "xxx" set colum B to Red... but i can't see any way to set the color of the colum based on Top/Bottom value for an other column.

 

Is there a way to achieve what i want