Select a cell, then Format -> Confitional Formating
.
I want to achive the following
- Red when value < 0
- Green when value > 0
- Leave it as it is when 0
First rule Less than
with value 0
, set Text to red color for Formating Style.
Click on Add another rule
.
Second rule Greater than
with value 0
, set Text to green color for Formating Style.
You might want to Copy Confitional Formating to Multiple Cells.