Click on a Cell/Row to Display Different Background Colors

In the report development process, you usually encounter report linkage scenarios. Usually, you need to change the background color of the currently clicked cell or the current row to bring us a good visual experience. So here's how to use conditional attributes to realize the click-to-color change that is supported by both the PC and mobile terminals.

Here we realize it by bringing its own function condition attribute and hyperlink function.

•  Set the dynamic parameters of the hyperlink and pass the value of the currently clicked cell.

• The condition attribute judges the current dynamic parameter value (that is, the value of the current cell) to change the background color of the current cell or row.
  

1.Add hyperlink

First select the cell to be clicked, Hyperlink>Dynamic Parameter, set the dynamic parameter naming parameter, and set the formula in the parameter value to fill in the cell to be clicked.

 2. Configure condition attributes

We have set the dynamic parameters, then when clicked, the value of the currently clicked cell will be passed as the parameter, the parameter name is str (you can customize the name), and then we will configure the condition attribute, the same is to add the condition on the A2 cell Property> drop-down selection box to select the background can be set to take effect on the current row or current cell, and then set the operator to equal to in the conditions below, and use the formula to write the following value into $str (use the $ sign and the parameter name to get the parameter )

After such a configuration, we can achieve what we need to click on the current cell to change the color of the current cell or the current row.

PC terminal

App

H5

Click on a Cell or Row to Display Different Background Colors.cpt