Border Range
The Border Range function draws a border around the outside (and optionally inside) of the Apply To range.
Settings | |
|---|---|
Thickness | The thickness of the border to draw. |
Color | The color of the border to draw. This can either be Automatic (based on the theme of the template), a specific color listed or a numeric color in the R,G,B format. For example, the RGB of a gray border is 128,128,128. |
Line Style | The style of the border lines drawn which can be Continuous for single lines or Double for double lines. |
Inside Border | This determines if inside borders are applied to the range. These can be applied just the Columns of the range, Rows of the range or Both rows and columns in the range. |
Example
A batch report template is created to retrieve 1-minute samples over the duration of the batch from historical data. A border should be drawn around the data for completeness. Since batches run at different durations, the border cannot be drawn on the template. This function is used to draw this border after the data is retrieved. Data starts on $B$8:$H$8. The settings for the function are:
Apply To | |
|---|---|
Cell | $B$8:$ H$8 |
Direction | Down |
End | All cells are empty |
Setting | Value |
|---|---|
Thickness | Thin |
Color | Automatic |
Line Style | Continuous |
Inside Border | None |