Practical Excel skills sharing: add switches to conditional formatting

Excel is a software that we often use to make charts. Today I will share with you some Excel usage tips. This article will help you implement Excel data bars with switches and conditional formatting. Adding the switch, I hope it will be helpful to everyone!

Hello friends, everyone must have used conditional formatting, but I guess many friends have never used conditional formatting with switches.

Today Lao Zhu will share with you an interesting and practical Excel skill-adding switches to conditional formatting.

Let’s take a look at the effect first:

Achieving such an effect is actually very simple, let’s do it step by step.

Step 1:

Select the cell range and set conditional formatting:

Step 2 ：

The next step is to add a switch for conditional formatting. First insert the control under the [Development Tools] tab.

Then right-click the control, set the control format, and let the control control an arbitrary blank cell. Here we choose to control B1.

Step 3:

Select the data area and set the conditional format again.

Step 4:

Getting closer and closer to success, next we keep the cell area selected and manage Conditional formatting rules.

In the pop-up dialog box, select the first format rule and check "Stop if true".

OK, now we can click on the control to control the display of conditional formatting:

How about it, it’s that simple, you can try it too Bar.

Today’s practice file is here:

https://pan.baidu.com/s/1kLqcAuBX_L7HwrEzu9kzig

Related learning recommendations: exceltutorial

The above is the detailed content of Practical Excel skills sharing: add switches to conditional formatting. For more information, please follow other related articles on the PHP Chinese website!