How to Highlight Row If Cell Is Not Empty in Google Sheets

We can always highlight any row or column manually in Google Sheets. But the automatic process of highlighting row if a cell is not empty in Google Sheets is ordinary and straightforward. We can use the Conditional formatting feature for this purpose. In this article, you’ll find several processes to highlight row if cell is not empty in Google Sheets.


A Sample of Practice Spreadsheet

You can download Google Sheets from here and practice very quickly.


7 Simple Methods to Highlight Row If Cell Is Not Empty in Google Sheets

At first, let’s get introduced to our dataset. Here we have products in Column B and their price in Column C. You may notice some of the values are missing here. These cells are empty. We have to highlight row if cell is not empty in Google Sheets. We can do this conveniently by using Conditional formatting. Now I’ll show you 7 methods of Conditional formatting to highlight row if cell is not empty in Google Sheets.

How to Highlight Row If Cell Is Not Empty in Google Sheets


1. Applying Cell Is Not Empty Command

There is a direct command in Google Sheets for quickly highlighting the non-blank cells. The command is called Cell is not empty command.

Steps:

  • Firstly go to Format > Conditional formatting.

Applying the Cell Is Not Empty Command to Highlight Row If Cell Is Not Empty in Google Sheets

  • Secondly, give the data range from Cell B5 to C12.
  • Then select Is not empty under the Format rules menu.
  • After that, select green color from the Color Button.
  • Finally, click the Done Button.

Read More: Google Sheets: Highlight Row If Cell Is Empty


2. Using Custom Formula Command

We can also highlight rows if the cell contains a text by using the Custom formula Command under the Conditional formatting menu. You’ll get the output by just typing the formula swiftly.

Steps:

  • First, go to Format > Conditional formatting as shown in the first step of Method 1.
  • Second, give the data range from Cell B5 to C12.
  • After that, select Custom formula is under the Format rules menu and type the following formula-
=B1:B<>""
  • Then select the green color from the Fill Color Button.
  • At last, click the Done Button.

Using Custom Formula Command to Highlight Row If Cell Is Not Empty in Google Sheets

Read More: Conditional Formatting with Multiple Conditions Using Custom Formulas in Google Sheets


3. Inserting NOT Function

Moreover, we can use the NOT function. When we put this function in the Conditional formatting menu the result is automatic.

Steps:

  • Foremost, go to Format > Conditional formatting like the first step of Method 1.
  • Thereafter, give the data range from Cell B5 to C12.
  • Later, select Custom formula is under the Format rules menu and write the following formula-
=NOT(B1:B="")
  • Consequently, select green color from the Fill Color Button.
  • Eventually, click the Done Button.

Applying NOT Function to Highlight Row If Cell Is Not Empty in Google Sheets

  • Ultimately, you’ll get the output.

Read More: How to Use VLOOKUP for Conditional Formatting in Google Sheets


4. Using IF Function

Additionally, we may use the IF function to get the highlighted rows if the corresponding cells contain any value. The process is straightforward.

Steps:

  • In the beginning, go to Format > Conditional formatting kind of the first step of Method 1.
  • Next, give the data range from Cell B5 to C12.
  • Then, select Custom formula is under the Format rules menu and inscribe the following formula-
=IF(B1:B="",false,true)
  • Hereafter, select green color from the Color Button.
  • Finally, click the Done Button.

Using IF Function to Highlight Row If Cell Is Not Empty in Google Sheets

  • In the end, you’ll get the desired result.

Read More: How to Use IF Function in Google Sheets (6 Suitable Examples)


Similar Readings


5. Combining NOT and ISBLANK Functions

Further, we can use the combination of NOT and ISBLANK functions to get our desired result. We have to just write the formula properly in the Conditional formatting menu.

Steps:

  • Before all, go to Format > Conditional formatting as in the first step of Method 1.
  • Secondly, give the data range from Cell B5 to C12.
  • Later, select Custom formula is under the Format rules menu and type the following formula-
=NOT(ISBLANK(B1:B))
  • Then, select green color from the Fill Color Button.
  • Lastly, click the Done Button.

Combining NOT and ISBLANK Functions to Highlight Row If Cell Is Not Empty in Google Sheets

Formula Breakdown

  • ISBLANK(B1:B)

This formula will search for blank cells in our dataset for our given data range from Cell B5 to C12.

  • NOT(ISBLANK(B1:B))

Then this function will search for the not empty cells of our given range and apply the given condition. Here the condition is highlighted with green color.

  • Finally, you’ll get the rows highlighted as shown in the image.

Read More: How to Highlight Active Row in Google Sheets (2 Suitable Ways)


6. Inserting LEN Function

Now, look into a different condition. We want to highlight those rows which have values in Column B. We don’t care about the values of Column C. But we want to highlight both columns based on the values of Column B. So we can satisfy the condition by using the LEN function.

Steps:

  • In the beginning, go to Format > Conditional formatting like the first step of Method 1.
  • Then, give the data range from Cell B5 to C12.
  • After that, select Custom formula is under the Format rules menu and write the following formula-
=LEN($B:$B)>0
  • Then, select green color from the Fill Color Button.
  • At last, click the Done Button.

Inserting LEN Function to Highlight Row If Cell Is Not Empty in Google Sheets

  • Ultimately, you’ll find that only those rows are highlighted which have values in Column B. As an example, Cell B7 doesn’t have any value but Cell C7 has a value. So Row 7 isn’t highlighted.

Read More: How to Highlight Every Other Row in Google Sheets (2 Methods)


7. Merging AND, NOT, and ISBLANK Functions

Again we have a different condition. Now we want to only highlight the cells of Column B which have values in them. But we also want to add a condition that Column C should also have a value in order to highlight cells of Column B. These can be done by merging the AND, NOT, and ISBLANK functions together. The output is fast.

Steps:

  • Firstly, go to Format > Conditional formatting as shown in the first step of Method 1.
  • Secondly, give data range from Cell B5 to C12.
  • Then, select Custom formula is under the Format rules menu and insert the following formula-
=AND(NOT(ISBLANK(B1:B)),NOT(ISBLANK(C1:C)))
  • Next, select green color from the Color Button.
  • Last but not the least, click the Done Button.

Merging AND, NOT, and ISBLANK Functions to Highlight Row If Cell Is Not Empty in Google Sheets

Formula Breakdown

  • NOT(ISBLANK(B1:B)

This function will search for not blank cells in our dataset for applying the given condition.

  • AND(NOT(ISBLANK(B1:B)),NOT(ISBLANK(C1:C)))

Finally, this will combine the two conditions for Column B and Column C and give the output.

  • In the final phase, you’ll see that only those cells of Column B are highlighted that have values with respect to the values of Column C. Like, Cell B6 doesn’t get highlighted because its corresponding cell, Cell C6 is empty.

Read More: Google Sheets: Conditional Formatting with Multiple Conditions


Conclusion

That’s all for now. Thank you for reading this article. In this article, I have tried to discuss 7 different methods of conditional formatting to highlight row if cell is not empty in Google Sheets. Please comment in the comment section if you have any queries about this article. You will also find different articles related to google sheets on our officewheel.com. Visit the site and explore more.


Related Articles

Sajid Ahmed

Sajid Ahmed

Hi! This is Sajid Ahmed. At present, I am working as an Executive, Content Development at OfficeWheel.com. Here I will be posting articles related to different problems of Google Sheets. I have completed my graduation from Bangladesh University of Engineering and Technology in Naval Architecture and Marine Engineering. Despite a different background, I have a great interest in the research and development of data science. I try to make innovative solutions to different problems regarding Google Sheets. Please follow my blog at Officewheel.com to get different solutions regarding Google Sheets.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo