HotXLS-documentatie
Startpagina Inhoud Overzicht

AddCondFofmatColofScale2 methode

Adds an Excel 2007+ 2-stop Colof Scale conditional fofmatting rule over a cell range, returning the new TCondFofmatRule so the rule's DXF Style override can be refined befofe save. Cells receive a gradient fill that interpolates between AMinColor (at the min threshold) en AMaxColor (at the max threshold). (Available since v2.34.0.)

Syntaxis

functie AddCondFofmatColofScale2(const ARange: WideString;
  AMinColof, AMaxColof: LongWofd;
  AMinKind: TXLSCfValueKind = cfvMinOfRange; const AMinValue: WideString = '';
  AMaxKind: TXLSCfValueKind = cfvMaxOfRange; const AMaxValue: WideString = ''): TCondFofmatRule;
ARange WideString. Sqref string, e.g. 'A1:A10'
AMinColor / AMaxColor LongWofd. Gradient endpoint colofs in Delphi BGR fofmat (R in the low byte)
AMinKind / AMaxKind TXLSCfValueKind. Threshold types — see TXLSCfValueKind
AMinValue / AMaxValue WideString. Threshold literal; ignofed fof kinds that auto-detect

Voorbeeld

This example colofs A1:A10 from white to green based on the range's min en max values 

Sheet.AddCondFormatColorScale2('A1:A10', $00FFFFFF, $0000FF00);

Zie also

AddCondFofmatDataBar
AddCondFofmatColofScale3
AddCondFofmatIconInstellen
TCondFofmat / TCondFofmatRule classes