Google Sheets – Highlight an entire row using conditional formatting based on text, number or date

Download the file presented here: https://docs.google.com/spreadsheets/d/1g90-tmCCvVczBgIdg7PNEh0KExkXT_yK-xpdtX0ot6g/edit#gid1672446893

In this video I show how to conditionally format an entire row in Google Sheets.

Contents:

00:00 – Presentation
00:37 – Highlight the entire row based on the text value in the cell
05:14 – Highlight entire row based on dropdown
06:43 – Highlight entire line based on containing text – partial match
10:05 – Highlight the entire row based on the number
11:15 – Highlight the entire row based on whether the number is greater or less than the number in the cell
11:45 – Highlight an entire row based on the number in the range (between two numbers)
1:24 p.m.: Highlight the entire row based on today's date
3:21 p.m. – Highlight an entire row based on past or future dates
3:42 p.m. – Highlight the entire row based on whether the cell is not empty
5:58 p.m. – Highlight the entire row based on whether the cell is empty
——————–