Unable to create a script. I would like to know if there is one that would allow me to color an entire row based on the value (a different color value) that I will find in the cells of column B. For example, I want to color all rows that have the same value in the column B with the same color. For example If I have X in cell B2, B6, B8 The rows 1,6 and 8 in blue, if I have Y in B1, B5, B7 The rows 1,5,7 must be in green, etc.  Only 10 possibilities with the conditional formatting, it's not enough for me.
How do I conditionally format based on the value of cells in a column?
google spreadsheets;google apps script