Forum Discussion
Table conditional cell colors
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 To access conditional formatting in tables right click the column and click conditional formatting as below.
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..
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.
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