I have conditional formatting on a column (B), based on the text that is entered. This is on a spreadsheet that has a dynamic calendar list, so the cell could change colour based on the day/month/year. Is there a way that the whole row can be colour filled to match the colour fill in column B?

​I have conditional formatting on a column (B), based on the text that is entered. This is on a spreadsheet that has a dynamic calendar list, so the cell could change colour based on the day/month/year. Is there a way that the whole row can be colour filled to match the colour fill in column B?   Read More

​