Is it possible to assign conditional formatting to

2019-07-26 09:18发布

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:

enter image description here

2条回答
聊天终结者
2楼-- · 2019-07-26 09:29

enter image description here

this is not possible in Google Sheets


for the custom formula you need to wrap it into INDIRECT formula like:

0

查看更多
我欲成王,谁敢阻挡
3楼-- · 2019-07-26 09:50

I think it is not possible, it is not documented in official docs.

Range names:

  • Can contain only letters, numbers, and underscores.
  • Can't start with a number, or the words "true" or "false."
  • Can't contain any spaces or punctuation.
  • Must be 1–250 characters.
  • Can't be in either A1 or R1C1 syntax. For example, you might get an error if you give your range a name like "A1:B2" or "R1C1:R2C2."
查看更多
登录 后发表回答