Forum Discussion
MaxH
Nov 01, 2023Copper Contributor
Conditional Formatting of Full Row Based on Data in One Cell Troubleshooting
Hey all!
I'm building a basic spreadsheet where I want the full row to be formatted based on a single cell. I can get the cell itself to format with the formula I'm using, but once I try to "Apply to" the range "=$1:$50", it fills almost every row with the conditional formatting, including rows for which the data in the chosen column doesn't fit the formula.
I put screenshots below
Any suggestions?