CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulags-conditional-formatting
gssi
gssi

Reputation: 5071

Google Sheets Conditional formatting does not support Defined Name ranges

My conditional format formula is:

=indirect(cell(Laddress,index(InitGrid,row(D4)-RorgRC,column(D4)-CorgRC)))

This formula works fine in a spreadsheet cell - i.e. all addressing works.

Any thoughts?

Upvotes: 0

Views: 249

Answers (1)

player0
player0

Reputation: 1

in Google Sheets' Conditional formatting (and Data Validation) all references to another sheet (even named ranges) need to be wrapped into INDIRECT formula.

Upvotes: 1

Related Questions