In this article:

Apply Conditional Formatting To An Entire Row in Google Sheets

May 8, 2024

In this article we will show you how to apply conditional formatting to an entire row in Google Sheets. Simply follow the steps below.

Apply Conditional Formatting to an Entire Row:

For this demonstration an example data set has been created. Click here to access the link and follow along at home.

Our example shows 7 people and their ages. We want to apply a custom format of all rows where the person's age is less than 33.

To do this we need to use conditional formatting with a custom formula.

1. Highlight the desired rows

Highlight the rows you wish to apply the conditional formatting to by clicking and dragging over the row numbers.

If you want to select individual or separate rows press and hold the Ctrl (Cmd ⌘ on Mac) key as you click each row.

In our example we want all the rows to be included so will highlight them all excluding the header row.

Google Sheets conditional formatting row: Select rows

2. Click Format > Conditional formatting

From the navigation bar at top of the display click Format. Then click Conditional formatting.

Google Sheets conditional formatting entire row

3. Set the Format rule to “Custom formula is”

The conditional formatting rules will appear on the right hand side of the display.

Conditional formatting Google Sheets entire row: Set format rule

Expand the dropdown menu in the Format rules section labelled Format cells if ..

By default this will displayis not empty”, change this to Custom formula is by selecting this option at the bottom of the dropdown menu:

How to apply conditional formatting to entire row Google Sheets: Custom formula is

4. Enter the custom formula =$Column and First_Row [Statement]

An input box will now appear, enter your custom formula:

=$Column and First_Row [Statement]

Formula Breakdown:

Column and First_Row: This will be the column the formula will search followed by the first row number of your selection. Note: It is important to match the first row number to the first row in your selected cell range. 

[Statement]: This will be whichever statement you want to include in the formula. We will use a less than statement in our example.

In our example the custom formula will start with =$C4. As we want to apply the formatting to all rows where the age is less than 33 we need to include the following statement <33.

Our full custom formula for our example is:


Conditional formatting whole row Google Sheets: Entering the custom formula

5. Set the formatting style

In the Formatting style section set the desired format of all rows that meet the conditions. There are several formatting options including text and cell color and the option to bold, italic, underline or strikethrough the text.

For our example we set the format to underline the text and turn the cell color orange.

Apply conditional formatting to entire row Google Sheets: Format style

6. See the results by clicking done

At the bottom of the formatting rules section is the Done button. Click this and the conditional formatting will be applied and results will display if the conditions are met.

In our example all rows which contain the age number under 33 are now formatted to our conditions.

Conditional formatting Google Sheets entire row: Results

Use our due date tracking software to easily automate due date reminders from your spreadsheet in just a few clicks. 

If you enjoyed this article, you might also like our article on how to set up Google Sheets conditional formatting based on another cell text or our article on how to set multiple conditional formatting in Google Sheets. 

If you want to learn how to extract names from email addresses, we also suggest checking out our detailed guide.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->