Format Range
The Format Range function applies formatting to the Apply To range. This includes any conditional formatting configured.
Settings | |
|---|---|
Based on | This determines range within the Apply To range to get the formatting from. This can either be the Topmost Row or Leftmost Column of the range. |
Adjust Column Widths | When set to Yes, the column widths of the Apply To range is resized based on its content. This is only applicable when Direction is set to Across. |
Stripe Color | If set, the background color added to the range at the Stripe Interval specified. This can either be a specific color listed or a numeric color in the R,G,B format. For example, a gray stripe could be specified as 128,128,128. |
Stripe Interval | If a Stripe Color is specified this defines the interval at which to apply the striping. If the Direction is Down this interval represents rows. If the Direction is Across this interval represents columns. |
Border Range | If set to Yes, an outside border is added to the range. The border is thin, continuous and uses the Automatic color setting. If something more specific is required, set this to No and configure a Border Range function. |
Example
A batch report template is created to retrieve 1-minute samples over the duration of the batch from historical data. Every fourth row should be colored in a light blue and a border should be drawn around the data for completeness. Since batches run at different durations, the striping and border cannot be drawn on the template. The Format Range function is used to stripe and 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$:$H$8 |
Direction | Down |
End | All cells are empty |
Setting | Value |
|---|---|
Based On | Topmost Row |
Adjust Column Widths | No |
Stripe Color | Sky Blue |
Stripe Interval | 4 |
Border Range | No |