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.

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.