Check out my brand new beginner’s course: Google Sheets Essentials.
This is a 100% online, on-demand video training course designed specifically to help you boost your spreadsheet skills.
Conditional formatting is a super useful technique for formatting cells in your Google Sheets based on whether they meet certain conditions.
For example, you could use it to apply background colors to cells based on the value in the cell.
You can go further than this though, and apply the formatting across an entire row, based on the value in a single cell.
For example, if the continent is “Africa” in column C, you can apply the background formatting to the entire row (as shown by 1 and 2):
Five steps to apply conditional formatting across an entire row
It’s actually relatively straightforward once you know the technique using the $ sign (Step 5).
Step 1. Highlight the data range you want to format
The first step is to highlight the range of data that you want to apply your conditional formatting to. In this case, I’ve selected A2:C13:
Continue reading How to apply conditional formatting across an entire row in Google Sheets