add cell color based on value table

[Bram12]

Hi,

I'm trying to change the cell color of the first column of my table based on the average value (second column). The table is created in query with the formula for a descriptive statistics table. Now I want to change the background color of the cells based on average value (<6 red, <8 orange, <=10 green) but this doesn't work so far. Does someone maybe have a solution for this?

[iceparrot]

Hey @Bram12 , 
instead of FIELD VALUE I'd suggest using RULES then you can set the parameters when which colour should be used as background colour in your table. 

Hope this helps you.

[Bram12]

Thank you for the respons. Unfrotunately does this not solve my problem. The color still does not change.