Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
So I have data in columns that are non adjacent and would like to treat them as one named range is that possible the columns are highlighted in blue and are as follows b3:b25,l3:l25,v3:v25 https://docs.google.com/spreadsheets/d/1dJQrF6yXmA6UHHfsCY0RIkPAMKTziRn3fqtpLbO3hH4/edit?usp=sharing
I tried curly brackets {b3:b25,l3:l25,v3:v25} but it says invalid range
A named range must point to a rectangular contiguous range of cells in a sheet.
If you just want to apply a conditional formatting rule to those columns, put the list of ranges in the Apply to range box, omitting the curly brackets.
If you want to refer to that list of columns in a formula, use the { array expression } you quoted, or use filter() or choosecols() to pick the columns of interest.
