Forum Discussion
Colour fill a whole row based on formatted cell colour
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?
If your current conditional formatting rule is applied to column B with rule formula like =B1="something", modify it applying to $A$1:$Z$1000 or like with formula =$B1="something"
- Thanks Sergei, I will give that a try!
