Forum Discussion

ColombianWoman's avatar
ColombianWoman
New Member
10 years ago
Solved

Table conditional cell colors

Hello

I want to make a table with a conditional cell background color, with three colors, red, yellow and green.  If the value is greater than the specific value turn red, if the value is near to the specific value turn yellow and if the value is lower than specific value  turn green.  How can I do this? 

 

  • Vvelarde's avatar
    Vvelarde
    10 years ago

    Its no possible yet put >,<

     

    I recommended to maximum value or mininum value depend what you want put the nearest minimum (or Maximum).

     

    Example:

     

    i Want;

     

    Red for values lower than 10

    Yellow for values 10

    Green for values upper than 10

     

    in format conditional box:

     

    Put

    Lower

    Value 9

    Middle

    Value 10

    Upper

    Value 11

     

     

     

     

     

6 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    ColombianWoman To access conditional formatting in tables right click the column and click conditional formatting as below.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    • ColombianWoman's avatar
      ColombianWoman
      New Member
      10 years ago

      Thank you very much for your help...I tried in that way but i do not know why just function with two colors, when i selected the three colors change and it is not correct.  I need manage the three colors like a light (red, yellow and green) in what part i can put conditional if valor = 5 turn green , if valor = 4 turn yellow or if valor >5 turn red.  I need something like that.   Can you help me again?

       

      Thanks..