Forum Discussion
ColombianWoman
10 years agoNew Member
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 th...
- 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
Vvelarde
10 years agoCommunity Champion
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
10 years agoNew Member
Victor thank you very much...OMG! I need to manage a range for each color.
You are very kind :)