Google Sheets Conditional Formatting rows based on color adjacent

Question

I am using Google Sheets to make a homework spreadsheet and have used conditional formatting to arrange assignments by the due date and also each class has a color. When I type in a class it automatically changes the cell to the class color but I want the rest of the row to be a pastel version of the class color. I am now trying to figure out how to automatically change the color of cells C3 - F3 in relation to the color of cell B3. Is there any way to do this? Image shows my spreadsheet set up and how different classes have different colors

Answer 1

If you use an $ to fix the column letter, you can use conditional formatting to apply to the entire row based on a single column (or the other way around, if you fix the row number and base it on the top row values).

So, if I want the rows in columns B to E to change colour if the value in the A column is 1, I would use the condition =$A1=1 for cells B:E.