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

1 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.

google sheets: conditional formatting of subsequent columns

  • Thank you, unfortunately, my column doesn't have numerical values but text so I don't think that would work. I attempted to use an (=IF($A1="name of class") but it didn't seem to work.
    – Sarah
    Jan 6, 2022 at 14:59
  • Text also works! I added a screenshot based on yours, have a look. Use quotation marks around the text string. You can also make this thing more dynamic by making these formulas refer to a separate list of class names, that way you don't have to alter the conditional formats every semester.
    – MiG
    Jan 6, 2022 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.