excel有条件的隐藏某行_暂时隐藏Excel条件格式

excel有条件的隐藏某行

暂时隐藏Excel条件格式 (Temporarily Hide Excel Conditional Formatting)

To highlight specific cells on an Excel worksheet, you can use conditional formatting. In the example shown below, orders with a quantity greater than 50 are highlighted with green fill colour.

要突出显示Excel工作表上的特定单元格，可以使用条件格式 。 在下面显示的示例中，数量大于50的订单以绿色填充颜色突出显示。

This was the result of simple conditional formatting, based on the cell value.

这是基于单元格值的简单条件格式设置的结果。

Sometimes though, the conditional formatting can be distracting, and there's no built in way to temporarily remove it.

但是有时候，条件格式可能会分散注意力，并且没有内置的方法可以临时删除它。

创建一个开/关开关 (Create an On/Off Switch)

Instead of removing the conditional formatting, you could add an On/Off switch to your worksheet, and only show the conditional formatting when the switch is on.

您可以在工作表上添加一个On / Off开关，而不是删除条件格式，并且仅在该开关打开时显示条件格式。

In the screenshot below, there's a cell named CondF_Show, and it has a data validation drop down for Yes and No.

在下面的屏幕截图中，有一个名为CondF_Show的单元格，它的数据验证下拉列表为Yes和No。

I changed the conditional formatting to a formula that checks both the Quantity cell value, and the value in the CondF_Show cell.

我将条件格式更改为可同时检查“数量”单元格值和“ CondF_Show”单元格中的值的公式。

Then, when the CondF_Show cell is changed to No, the conditional formatting is temporarily hidden.

然后，当CondF_Show单元格更改为否时，条件格式被暂时隐藏。

翻译自: https://contexturesblog.com/archives/2010/05/24/temporarily-hide-excel-conditional-formatting/

excel有条件的隐藏某行