Documentazione HotXLS
Home Contenuti Panoramica

AddCondFormatColorScale2 metodo

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 override può essere raffinato prima del salvataggio. Le celle ricevono un riempimento sfumato che interpola tra AMinColor (at the min threshold) e AMaxColor (at the max threshold). (Available since v2.34.0.)

Sintassi

funzione 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

Esempio

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

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

Vedere also

AddCondFormatDataBar
AddCondFormatColorScale3
AddCondFormatIconSet
TCondFormat / TCondFormatRule classes