Hi All,

Does anyone the easiest way to change a tablerecords cell back/fore colour.
But based on 2 tables.
So i have 2 data tables. Exactly the same structure. Exactly the same amount of rows
Except the values are different.
Data Table 1 is the table being displayed and contains actuals
Data Table 2 is the baseline (not fixed numbers)
I want to compare the actuals against the baseline. If its more then Colour A, if its less Colour B OR if its within a certain % then colour C.

I thought i could achieve it by looping through each data table cell and retrieve the value using the rownumber currently on, and then the column name in the structure. Then use IF statements to make the comparison. 

But then im stuck on how i would achieve setting the Back Color / Fore color of the actual cell in TableRecords itself

Am i going down the right path, or is there another method that this can be achieved?

Thanks :)