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


1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.