Excel：如何进行 DRY 格式？
我有一些条件格式样式。我不想继续为新范围创建新规则；我宁愿遵循 DRY 声明一次并在其他地方引用它。我很难做到这一点。
当条件格式规则只有一个范围时，它可以正常工作。
=Travel!$C$5:$P$8
但是，我随后尝试在另一张纸上添加另一个范围，但失败了。
=Travel!$C$5:$P$8,Equipment!$B$5:$H$11
当我单击“应用”时，电子表格上没有任何反应，并且相关规则的范围会自行重置对此：
=Travel!$C$5:$P$8
有办法做到这一点吗？
I have some conditional formatting styles. I don't want to keep creating new rules for new ranges; I would rather follow DRY by declaring it once and referencing it elsewhere. I'm having difficulty doing this.
The conditional formatting rule works fine when it's just one range.
=Travel!$C$5:$P$8
However, I then try to add another range on another sheet, and it fails.
=Travel!$C$5:$P$8,Equipment!$B$5:$H$11
When I click "Apply", nothing happens on the spreadsheet, and the range for the rule in question resets itself to this:
=Travel!$C$5:$P$8
Is there a way to do this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
同一规则不能同时应用于 2 个不同的工作表。您必须为设备表创建单独的规则。我一时兴起尝试创建一个覆盖 2 个不同工作表上的单元格的命名范围，然后尝试使用该命名范围作为适用于范围的内容，但没有运气。
The same rule cannot apply to 2 different sheets at the same time. You'll have to create a separate rule for the Equipment sheet. I tried on a whim to create a named range that covered cells on 2 different sheets, then tried using that named range as the applies to range, but no luck.