Google Sheets - Data Validation - Using Formula in List from range

user_14776142 0
Viewed 298

enter image description here

I am trying to create a custom dropdown for each row depending on the content of a cell in the same row. I have tried several other ways but they do not work when you filter.

The formula I am using will be put in the range section here.

this is the formula :

=concatenate("'Working'!$AG",(match(C2,Working!D:D,0)),":","$AK",(match(C2,Working!D:D,0)))

This would output Working!$AG3:$AK3 which would be a valid range and return the correct result. Help, please

conditional-formatting google-sheets-formula google-sheets concatenation validation
1 Answers

That is not possible. No formulae other than simple range references can be used in conditional formatting criteria when List from a range is selected

(currently in June 2022)

user_56326290
Related