How to Apply Conditional Formatting Strikethrough in Google Sheets

How to apply google sheets conditional formatting strikethrough 13

In this article we will learn about what is Strikethrough in google sheets and How to Apply Conditional Formatting Strikethrough in google sheets with real life problem statement and solution.

What is Google Sheets Conditional Formatting Strikethrough?

Google Sheets allows the feature of Conditional Formatting which allows us to automatically format the cells according to conditions provided. It saves up a lot of time of user. We can use Conditional Formatting to format cells in different styles as per our requirements. We can also use conditional formatting to strikethrough the text in the cell. Here we can use Google Sheets Conditional Formatting Strikethrough for such cases. In this article, we will provide an easy and step by step procedure to show how to Apply Google Sheets Conditional Formatting Strikethrough.

Why we use Google Sheets Conditional Formatting Strikethrough?

It is possible that we are working on a sheet where information of multiple employees is stored. It includes the information of current employees as well as past employees, or similar case can be described when we are working on information of a company’s transactions record. It includes successful transactions as well as the ones which were later cancelled and the good were returned. In both the cases, we still need the other information; Information about the past employees and cancelled transactions. So, the best option here is to strikethrough the information that is not required right away and distracts us.

See also  How to Remove Hyperlinks in Google Sheets [4 Methods]

Google Sheets allows us to use Google Sheets Conditional Formatting Strikethrough. Using the method for Google Sheets Conditional Formatting Strikethrough, we can strikethrough the cells which are not currently required to be in use for better presentation and visualization of the Google Sheet.

Donwload/Copy Practice Workbook

How to apply Google Sheets Conditional Formatting Strikethrough

Let us take an example of a Google Sheet where information of employees is kept. Talking about employees’ information, we know that there may be thousands of employees in a company and the record may exceed thousands, so we have to strikethrough the Employee ID of those employees who have left or retired from the company so that when we look at the data, we know at a glance which employees are present in company.

Here we demonstrate the method on the sheet below:

How to apply google sheets conditional formatting strikethrough 1

Now, we need to apply google sheets conditional formatting strikethrough on those employees’ Employee ID whose contract status is closed.

Step 1:

Select the cells where you want to apply the Conditional Formatting.

In this case, we need to apply the Conditional Formatting to the employee ID to strikethrough itself where Contract Status is closed and also the highlight is removed.

So, we can manually select by clicking on A2 as:

How to apply google sheets conditional formatting strikethrough 2

OR

We can type the cell number A2 in “Name Box” as:

See also  How to Use Google Sheets Conditional Formatting Based on Another Column

How to apply google sheets conditional formatting strikethrough 3

Either way, we see that the selected cells are highlighted in light blue showing selection.

Step 2:

Now apply Conditional Formatting.

As the cell is selected, we can apply conditional formatting using any of the 2 methods below:

  • Method 1:
    • Right Click anywhere on the selected cell. A sub-menu will appear. Choose “View more cell actions” and then Conditional Formatting as shown below:
    • Right Click -> View More Cell Actions -> Conditional Formatting

How to apply google sheets conditional formatting strikethrough 4

  • Method 2:
    • From the Format toolbar, choose Conditional Formatting as shown below:
    • Format -> Conditional Formatting

How to apply google sheets conditional formatting strikethrough 5

As we click on Conditional Formatting, Conditional Formatting Rules Box will appear as:

How to apply google sheets conditional formatting strikethrough 6

Step 3:

Set the condition that is required to activate the conditional formatting.

Here, we need to strikethrough the cell if Contract Status is Closed. So, we apply the condition using a custom formula.

Select the Custom Formula Is under the Format Rules section in Conditional Format Rule Box as:

How to apply google sheets conditional formatting strikethrough 7

Now, enter the formula in the Formula Box in Format Rules section inside Conditional Format Rule Box. Here the condition is to check if Contract Status is Closed, so our formula here is “=E2=”Closed”. We apply it as:

How to apply google sheets conditional formatting strikethrough 8

We see that as we apply the formula, we begin to get change in our sheet that A2 is starting follow the conditional formatting as E2 satisfies the condition.

Step 4:

After setting condition, we set the “Format” for Conditional Formatting. We will set strikethrough format in Formatting Style section in Conditional Format Rule Box as:

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

How to apply google sheets conditional formatting strikethrough 9

Step 5:

Click “Done” to submit the conditional formatting.

How to apply google sheets conditional formatting strikethrough 10

We may submit the conditional formatting by clicking Done button or we may cancel it if we do not require this formatting using cancel button.

Step 6:

We need to apply the same formatting to the rows below as well. We can do that by copying cell and pasting the conditional formatting to the rest of the sheet.

We copy the cell as below:

How to apply google sheets conditional formatting strikethrough 11

Now, select the rest of the cells of the column and paste conditional formatting using special paste as:

Right Click – >Paste Special -> Conditional Formatting Only

How to apply google sheets conditional formatting strikethrough 12

And you can see the final result as:

How to apply google sheets conditional formatting strikethrough 13

Notes

We see that in this example, we used the formula as =A2=“Closed”. Quotation marks implies that a string of text is given inside and Google Sheet matches that string with A2, if it matches exactly then condition is satisfied, otherwise not. So be very careful with spellings in such cases.

Conclusion

Applying Google Sheets Conditional Formatting Strikethrough allows us to strikethrough the cells which are not of immediate use so that user would not waste time upon looking at all records and save up a lot of time; rather user will only look upon the records which are not strikethrough. In this article, easy step-by-step method for Google Sheets Conditional Formatting Strikethrough is described. Feel free to comment below for any queries.

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