How to Highlight Rows by Value in Google Sheets

by Sanj

To highlight rows based on the value in a column in Google Sheets and have the colors update automatically when the values change, you can use conditional formatting. Here's how you can set it up:

  1. Select the range of cells where you want the formatting to apply. For example, if you want to highlight rows starting from row 2, select the range from A2 to the rightmost column where you want the formatting to be applied (e.g., column Z).

  2. Go to the "Format" menu at the top of the Google Sheets interface and click on "Conditional formatting."

  3. In the Conditional format rules panel that appears on the right side of the screen, select "Format cells if" from the dropdown menu.

  4. In the first dropdown box, select "Custom formula is."

  5. In the input field next to it, enter the following formula for highlighting rows where column H has the value "apple":

  1. Click on the "Formatting style" button next to the formula input field and choose the desired formatting options, such as selecting the red color.

  2. Click "Done" to apply the formatting.

  3. Repeat steps 4-7 for the other two conditions. For the "berry" condition, use the following formula and choose the blue color:


For the "grapes" condition, use the following formula and choose the green color:


Make sure to change the formatting options for each condition accordingly.

Now, whenever the values in column H change, the corresponding rows will be highlighted with the respective colors.