Forum Discussion
TracyB33
Sep 26, 2024Copper Contributor
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/yea...
SergeiBaklan
Sep 26, 2024Diamond Contributor
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"
- TracyB33Sep 26, 2024Copper ContributorThanks Sergei, I will give that a try!