Forum Discussion

Bram12's avatar
Bram12
Regular Visitor
3 years ago

add cell color based on value table

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?

 

 

 

Need Help

2 Replies

  • iceparrot's avatar
    iceparrot
    Advocate II
    3 years ago

    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's avatar
      Bram12
      Regular Visitor
      3 years ago

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