是否有一种方法可以列出在另一张纸上触发有条件格式规则的单元格数？
我正在寻找一种列出所有触发条件格式规则（将单元格红或黄色）列为另一个工作表的单元组的行数。这可能吗？我有一个180,000行，我必须缩小到10％，然后向下滚动以查看突出显示的单元格。 不需要寻找代码就适当耗时
，只是在正确的方向上寻找轻推。 谢谢
I'm looking for a way to list all the row numbers of cells that have triggered a conditionally formatting rule (that changes the cell colour red or yellow) into another worksheet. Is this possible? I have a 180,000 rows and I'm having to zoom out to 10% then scrolling down to see the highlighted cells. It's properly time consuming
Not looking for the code, just looking for a nudge in the right direction.
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有条件格式的180,000行，哇，需要一段时间才能刷新。
虽然您无法根据条件格式的输出创建公式，但您可以创建一个公式，该公式将相同的处理逻辑与条件格式相同。我会这样处理：
filter（）在此处记录：
新列的数据表可帮助定位满足/不符合公式列中条件的行。
180,000 rows with conditional formatting, wow, that will take a while to refresh.
While you cannot create a formula based on the output of conditional formatting, you CAN create a formula that incorporates the same processing logic as conditional formatting. I would approach it like this:
Filter() is documented here: https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
If you run an older version of Excel that doesn't have Filter, you can sort the data table by the new column to help locate the rows that meet/don't meet the condition in the formula column.