I. Overview
1) You can highlight cell borders by conditional formatting.
2) This article shows how to highlight data with low inventory and those with inventory quantity less than order quantity.
3) Prerequisite: 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 data columns into cells
1) B3~E3: Drag data columns [Product_name]、[SupplierID]、[Inventory_quantity] and [Order_quantity] into cells.
2) B2~E2: Input the header and fill them with grey.
3) B2~E3: Set as center alignment and add borders.
4) Preview.
3. Select D3 and add condition
4. Setting of property
1) Click + to select the property: Border.
2) Click Edit and set the property of border:
Style: A thick line style.
Color: Orange Yellow.
Click External and then click OK.
5. Add common condition
1) Operator: Less Than.
2) Value Type: Integer.
3) Comparison Value: 10.
4) Click+to add the common condition.
6. Preview
When the number of inventory is less than 10, the borders of corresponding cells in the Inventory column are highlighted in orange yellow.
7. Select C3 and add condition
8. Setting of property
1) Click + to select the property: Border.
2) Click Edit and set the property of border:
Style: A thick line style.
Color: Red.
Click External and then click OK
9. Add Formula Condition
1) Type: Formula. Click Edit.
2) Define the formula: D3 < E3. Click OK. (Data columns [Inventory_quantity] and [Order_quantity] are inserted into D3 and E3 respectively)
3) Click + to add the formula condition.
10. Preview
When the inventory quantity is less than the order quantity, the borders of corresponding cells in the Supplier column are highlighted in red.