Dariusz - You will need to explain in more detail....how can other rows be colored based on the model of a single row only...do you mean that all duplicate rows or matching sets of rows in the Table View would be coloured the same?
I want to colour by a row. So for example the highest value in a row (not in a column) gets the darkest/lightes colour. Please let me know if this makes sense.
This is my data Table View (see attached) Colouring by a single column doesn't make sense here because I wont to see how metrics perform over the months which can be visible by colouring by a single row.
Dariusz - Not in the Table View....colouring in the Table View is based on columns/fields setting, with row-by-row variation settings to aid legibility/visibility vertically, not horizontally. More powerful conditional formatting options are available in HTML table layouts in the Content View.
The tab/page layout with horizontal timeslice orientation you are working with in this file may have been specified as a data delivery format to facilitate re-use, but horizontal rows of numbers are not easy to follow visually.
What you are looking for is something like 'sparklines', small horizontal lines that show the ups and downs in the horizontal time series row values, which are much more understandable than scanning horizontally across rows of figures, coloured or not.