Colour fill a whole row based on formatted cell colour

Question

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?

sergeibaklan · Answer

TracyB33&nbsp;
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&nbsp;=$B1="something"

tracyb33 · Answer

Thanks Sergei, I will give that a try!

Forum Discussion

Colour fill a whole row based on formatted cell colour

2 Replies

Resources