Auto Highlight an Entire Row Based on Values in a Single Column in a Spreadsheet
/ @theworkflow_
Custom conditional formatting can be tricky in sheets. It's all about the right formula. Here is a quick and easy way to use conditional formatting to automatically highlight an entire row (not just a single cell in a column) of your sheet based on the values in a single column.
Sample Sheet - https://docs.google.com/spreadsheets/...
0:00 - Intro
0:13 - The Basics
1:32 - The Trick
1:52 - Rinse and Repeat
2:12 - Works for new rows
2:30 - What else you can do