Forum Discussion

MaxH's avatar
MaxH
Copper Contributor
Nov 01, 2023

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?

 

Resources