Table conditional cell colors

[ColombianWoman]

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? 

[ankitpatira]

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

[ColombianWoman]

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.. 

[Vvelarde]

hi @ColombianWoman, try with this way:

[ColombianWoman]

Hola Victor, como vas

Gracias por responder....Mira que me sigue la duda en donde puedo validar los tres valores diciendo si es mayor igual(>=) o menor igual (<=) porque solo me premite escribir el valor pero donde le hago las validaciones a ese valor específico.  

Quedo atenta a tu respuesta.

[Vvelarde · Accepted solution]

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

[ColombianWoman]

Victor thank you very much...OMG!  I need to manage a range for each color.  

You are very kind 🙂