Multiple Format Ranges

You can apply multiple formatting instructions. Each column of the formatting range represents one parameter that can be applied to a formatting instruction.

Features

The following columns are all required, and you must enter them in the order described below. (You can skip the title row, which is not part of the range.)

Column	Description	Keywords
CRITERIA	Defines what triggers the formatting instruction. For example, the criteria could be based on the calculated or non-calculated status of a cell. Note The system does not support a comma delimited list of values in the Criteria column (except when you use the {dim.property}= {value} keyword. End of the note.	Default — applied regardless of criteria Calc — applied only to calculated members Input — applied only to noncalculated members {dim.property}= {value} — applied only to the members of dimensions {dim} with property {property} = {value} You can also you the different-from (<>) keyword.
EVALUATE IN	Allows you to restrict the range for which the criteria must be evaluated.	Row — Evaluate the criteria in ROW Column — Evaluate the criteria in COLUMN All or blank — Evaluate the criteria in PAGE or COLUMN or ROW or CELL Page — Evaluate the criteria in PAGE RowCol
FORMAT	Represents the desired formatting properties The definition of the format is directly driven by the Excel format of the FORMAT cell, as defined using the native Excel formatting tools. Note The format properties of a cell include the Lock property. This property is not visible unless you open the Excel Format Cell dialog box. The EvDRE formatting engine uses it to prevent or allow a user to modify the content of the cells or a workbook. End of the note.	Color, font size, font attributes
USE	Specifies which components of the defined format should be applied. EvDRE uses only the Pattern and the Fontsize properties of the FORMAT cell and ignores all other formatting properties (for example, font name, or border). By separating formatting options into independent groups the system allows you to overlay different settings that are not mutually exclusive, and combine them into the final result. Note The system supports all cell properties that use VBA syntax. The system does not support a comma delimited list of values in the USE column. End of the note.	All — Apply all formatting properties Pattern — Apply all the pattern formatting properties Number — Apply the number formatting properties Alignment — Apply the alignment (Center, Left, Right, Justified). Font — Apply all the font formatting properties FontStyle — Apply the font style only (regular, bold, italic) Border — Apply a border to each individual CELL in the range. Frame — Apply an external border to the RANGE as a whole. Style — Apply all style properties (as defined in Excel). Content — Apply what is in the cell itself. You can change the content; instead of showing the value you can override it with the text noted in the format range. If the value exceeds 1 million, you can change the content to say exceeds. Lock — Apply the LOCK property Protection — applies the entire Cell Protection section (Locked+FormulaHidden)
PARAMETERS	Used to enter some formatting instruction directly in textual format. For example, entering `FONTSIZE=”12”` defines in a textual format the font size to use. Note The system supports all cell properties that use VBA syntax. End of the note.	Fontsize=acccount.size Style — Content —
APPLY TO	Defines the sections of the report to which the format should be applied. EvDRE applies the defined format to only the headings area of the row/column containing a calculated member. If you leave this field is blank, the current formatting instruction is applied to only the data range. Note The system does not support a comma delimited list of values in the APPLY TO column. End of the note.	Blank — Apply to the Key Range, Headings Range, PageKey Range, and Data Range Heading Data — Apply to the Data range Key — Apply to the row or column Key Range

More Information

Format Ranges