IMinutesField.ConditionalFormula Property
A formula is always prepended with the '=' string. If there is no conditional formatting, this property is set to an empty string. Formulas are in the format of the en-Us culture.
The value contains 0 or more formatting condition rules.
The rules are separated with the '|$|' delimiter. Each rule consists of a formula and 11 optional formatting parameters. Each of these parts are separated with the '|~|' delimiter. The complete format of the rule parts is as follows:
- Formula
- FontBold
- FontItalic
- FontUnderline
- FontStrikeThrough
- FontColor
- BackColor
- PatternColor
- ColorIndex
- BackColorIndex
- PatternColorIndex
- PatternStyle
The boolean parts have values 0 for False, otherwise True. The RGB color parts contain a number created with Color.ToArgb method.
Values -3 are used when a value was not explicitly set.
The RGB colors are used in almost all cases. In this case, the indexed color values are -3. The indexed colors are only used for AUTOMATIC (-1) and NONE (-2).