セルの条件属性でハイパーリンクを設定

Sometimes under the same hyperlink node, it is often necessary to automatically judge and perform page link jumps according to different needs.

For example: click on the hyperlink A, when the value of A>50, it will redirect to https://www.baidu.com

1. Template design

Enter the formula in cell B2: =RAND()*(100-1)+1, the purpose is to randomly fetch numbers from 0-100.

The main body design of the report is as follows:

2. Set Conditional Formatting

Select cell B2, right-click Conditional Formatting, click "+" in the upper left corner, add a Conditional Formatting, and click "+" at the attribute on the right, select "Hyperlink", enter the hyperlink attribute setting page, and enter the formula The judgment condition $$$>50 ($$$ represents the current value), as shown in the figure below:

After the setting is complete, check the "Use Links" checkbox on the right side of the hyperlink and click Edit to enter the detailed hyperlink setting interface, as shown in the figure below:

Note: The URL here must include the https protocol, otherwise a 404 error will be reported.

Note: When parameters need to be passed in the hyperlink, add the parameters that need to be passed in the parameter column to realize the dynamic condition judgment hyperlink and carry the parameter transmission.

3. Effect preview

Preview the report, click on the randomly generated number, you can see the following effects:

Click to download: 

Jump_to_different_pages.cpt