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
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
Victor thank you very much...OMG! I need to manage a range for each color.
You are very kind :)