Google Sheets Change Text Color Based on Value (Conditional Formating)

May 25, 2019

Use conditional formatting.

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.

This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.