I. Overview
1) You can add hyperlinks to specific text by conditional formatting.
2) Prerequisites: Insert Data Columns, An Introduction of Conditional Formatting.
You will learn |
---|
|
II. Steps
1. Create a new dataset [ds1]
1) Create a new DB query dataset.
2) Drag the table [Product] into the DB query.
2. Drag datasets into cells
1) B3~E3: Drag datasets [Product_name], [SupplierID], [Inventory_quantity] and [Order_quantity] into cells.
2) B2~E2: Enter headers and fill them with grey.
3) B2~E3: Set as center alignment and add borders.
4) Preview.
3. Select D3 and add condition
4. Property setting
1) Click + to add the property: Hyperlink.
2) Check the box Use Links and click Edit to set the hyperlink property:
Click + to add hyperlink.
Hyperlink Type: Webreport
Webreport: GettingStartedEN.cpt.
Link Opened in: New Window
Parameter Passing Mode: None.
5. Add common condition
1) Comparison Operator: Less Than.
2) Value Type: Integer.
3) Value: Current Value Less Than 10.
4) Click + to add the common condition.
6. Preview
In the Inventory column, the figure less than 10 is hyperlinked.
7. Add [Font] to make the hyperlink obvious:
1) Foreground: Blue
2) Underline: Thin Line
3) Click OK.
4) Range: Current Cell
8. Preview
When the number of inventory is less than 10, the figure in corresponding cell is underlined, hyperlinked and colored in blue.