Conditional Formatting Across An Entire Row In Google Sheets
I learned this from this post.
I always have students submit a contact sheet with their preferred email and ideally, a gmail account. Since students are different classes, I use conditional formatting to highlight entire rows based on responses and classes.
Step 1: Highlight the entire range that you want the conditional formatting to apply to.
Make sure you select specific cells-- you may use A1:F (which highlights A1 to all of F):