Docs HotXLS
Accueil Sommaire Aperçu

AddCondFormatColorScale2-method

Adds an Excel 2007+ 2-stop Color Scale conditional formatting rule over a cell range, returning the new TCondFormatRule so the rule's DXF Style peut être affiné avant l'enregistrement. Les cellules reçoivent un remplissage dégradé qui interpole entre AMinColor (at the min threshold) and AMaxColor (at the max threshold). (Available since v2.34.0.)

Syntaxe

function AddCondFormatColorScale2(const ARange: WideString;
  AMinColor, AMaxColor: LongWord;
  AMinKind: TXLSCfValueKind = cfvMinOfRange; const AMinValue: WideString = '';
  AMaxKind: TXLSCfValueKind = cfvMaxOfRange; const AMaxValue: WideString = ''): TCondFormatRule;
ARange WideString. Sqref string, e.g. 'A1:A10'
AMinColor / AMaxColor LongWord. Gradient endpoint colors in Delphi BGR format (R in the low byte)
AMinKind / AMaxKind TXLSCfValueKind. Threshold types — see TXLSCfValueKind
AMinValue / AMaxValue WideString. Threshold literal; ignored for kinds that auto-detect

Exemple

Cet exemple colore A1:A10 du blanc au vert en fonction des valeurs min et max de la plage 

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

Voir aussi

AddCondFormatDataBar
AddCondFormatColorScale3
AddCondFormatIconSet
TCondFormat / TCondFormatRule classes