I. Description
When setting a hyperlink in the expanded data column, I hope that the links in different data columns point to different pages. How to set it?
II. Ideas
Set the hyperlink in the Conditional Formatting to solve the problem, that is, set multiple Conditional Formattings, and the web pages linked by each Conditional Formatting are different and determine which Conditional Formatting is executed by setting the conditions.
III. Examples
1. Conditional attribute settings
Right-click the cell, select the Conditional Formatting, add Conditional Formatting1, set as follows:
For details on how to add a hyperlink, please refer to Hyperlink
Also add a Conditional Formatting2, the modified attribute is the same as Conditional Formatting1, only need to modify the webpage and modify the conditions.
2. Pagination Preview
Click on the Pagination Preview, and then click on the corresponding area to see the jump to a different web page.