I'd like to apply a conditional formatting rule to a named range. Is that even possible? How do I do that? When trying to enter the Name of the Range to the Field where you set up the range the rule applies to it won't accept my input.
Also with INDIRECT
it does not work:
this is not possible in Google Sheets
for the custom formula you need to wrap it into
INDIRECT
formula like:I think it is not possible, it is not documented in official docs.