Please see attached for my desired effect. The overall mean of all the data in table is 0.28 (right-bottom of the table), and I would like a cell with value:
- less than 0.5 * mean: Red
- 0.5 * mean to mean: Amber
- greater than mean: Green
My query can return anything I need (including statistical results over the data) in any way. The problem is how to make the colouring scheme for each cell refer to a value not displayed in that cell.