How to Change Text Color Using Conditional Formatting in Google Sheets

google sheets conditional formatting text color

In this article we will discuss about conditional formatting and google sheets conditional formatting text color change.

Suppose a user has certain set of data, and he wants to change the text color or highlight the cells according to the cell values. If a person starts to do it manually it would definitely take hours for a medium range of data and even days for large amount of data. Even after all that effort, the data might be changed later leading to errors in specific formatting.

Best solution is to use Conditional Formatting which enables the user to provide certain conditions to the cells and upon those conditions, format of the cell(s) is decided. Common examples may include changing the text color of marks if student fails, text color green for successful deliveries, yellow for pending and red for unsuccessful ones and so on.

In this article, we will show you how to change text color using conditional formatting in Google Sheets.

Download/Copy Practice Workbook

How to Change Text Color Using Conditional Formatting in Google Sheets

Conditional formatting allows user to let sheets decide for themselves to apply different types of formatting to different cells based on the value (content) of the cell(s).

See also  How to Apply a Formula to an Entire Column or Row in Google Sheets

Google sheets enable one to use conditional formatting. One may add multiple rules (conditions) to one cell of sheets. The sheets will automatically check those conditions and apply formatting related to that. Google sheets allows us to change text color based on conditional formatting.

It is very useful in the types of scenarios where we have to assign different text colors to cells based on their content.

One simple scenario can be to assign text colors based on the status of deliveries:

  • Green for successful deliveries
  • Yellow for pending deliveries
  • Red for cancelled deliveries

Let us implement the above example to the Google Sheets and apply conditional formatting for text colors based on that. Here we are working on the data of a courier service and some of its delivery’s details are mentioned. We are supposed to assign green text color to the status if delivery is successful, yellow if pending and red if the delivery is cancelled so that the data is more arranged and clearly visible at a glance without actually reading the status of the delivery.

Procedure of Google Sheets Conditional Formatting Text Color

Step 1: Open the google sheet containing the cells where you want to change text color based on conditional formatting.

Here we take the following data:

See also  How to Compare Two Columns In Google Sheets (4 Methods)

google sheets conditional formatting text color 1

We can see that although the delivery status is properly written, it needs to be read thoroughly to understand the current status of courier company. And it can become easier at a glance with applying text color using conditional formatting.

google sheets conditional formatting text color 2

Step 2: You can either select all the cells at once which needs conditional formatting for text color, Or you can select a single cell and apply the conditional formatting to that cell and copy it to rest of the cells needing formatting.

Here we are selecting all the cells needing formatting as the number of cells needing the formatting are few and easily selected by dragging the mouse over it or using Shift+Click to multiple cells. We see that the selected cells are highlighted.

google sheets conditional formatting text color 3

You can check how to copy conditional formatting in Google Sheets to multiple cells using the link below:

How to Copy Conditional Formatting in Google Sheets (2 Methods)

Step 3: Right click over the selected cells, sub-menu will appear. Choose “View more cell actions” and further choose “Conditional Formatting”.

Right Click (Selected) -> View more cell actions -> Conditional Formatting

google sheets conditional formatting text color 4

Conditional Format Rule Box will appear as below:

google sheets conditional formatting text color 5

Step 4: Now we will apply the first rule based on requirements.

Green for successful deliveries, so the rule becomes:

google sheets conditional formatting text color 6

As we are applying the rule, we see that sheets are implementing them side-by-side.

See also  How to Use SUMIF in Google Sheets [User Guide]

Step 5: Now apply the rest of the rules by clicking on “Add another rule” in the bottom of the conditional formatting box. You can add as many rules as you want by clicking on “Add another rule”.

google sheets conditional formatting text color 7

Red for cancelled deliveries, the rule is as below. Now click on “Add another Rule” to add the last rule.

google sheets conditional formatting text color 8

Yellow for pending deliveries, rule is as follows:

google sheets conditional formatting text color 9

 

Step 6: Click “Done” to show the Conditional Formatting Rules to the designated cells are complete.

google sheets conditional formatting text color 10

You can also choose to “Cancel”, but it will only cancel the current rule being maintained while keeping the previous rules saved.

Data finally appears more arranged and visually appealing as:

google sheets conditional formatting text color 11

Notes

Once you click on “Add next rule”, the current rule showing in the panel gets submitted and panel now creates the next rule for conditional formatting. Even if you press cancel now it will only cancel the current rule in Conditional Formatting Rule Box. You can add, delete and modify the rules based on the choice.

Conclusion

Applying text colors using conditional formatting makes the google sheets more arranged, visually appealing, and properly organized. Above we have discussed about google sheets conditional formatting text color change, if you have any question regarding the topic, feel free to ask in comments section below.

Thanks for reading!

Content Protection by DMCA.com

Widad Khan

Hi, I am Widad Khan. I was born and raised in Pakistan. I have always loved the field of Computer Sciences and since I was a kid, I would say I wanna grow up to be a scientist, now this term is mostly related to "Computer Scientist" and not scientist alone. I am pursuing my Bachelor Degree in Computer Sciences from GCU, Lahore. I have always loved keeping records of different types of data. Earlier, I would use MS Excel for that. But with the advancements in Google Sheets, my work has become much easier. And also it's very easy to share and coordinate data with fellows and coordinates.

OfficeDemy.com
Logo
Enable registration in settings - general