Pridá pravidlo podmienečného formátovania
Farebná škála s 3 zastávkami Excel 2007+ nad rozsah buniek, vrátiac nové
TCondFormatRule. Bunky dostávajú interpolovanú farbu podľa svojej hodnoty
Syntax
function AddCondFormatColorScale3(
const ARange: WideString;
AMinColor, AMidColor, AMaxColor: LongWord;
AMinKind:
TXLSCfValueKind = cfvMinOfRange;
const AMinValue: WideString = '';
AMidKind:
TXLSCfValueKind = cfvPercentile;
const AMidValue: WideString = '50';
AMaxKind:
TXLSCfValueKind = cfvMaxOfRange;
const AMaxValue: WideString = ''):
TCondFormatRule;
| ARange |
WideString. Sqref String, e.g. 'A1:A10' |
| AMinColor / AMidColor / AMaxColor |
LongWord. Three gradient anchor colors in Delphi BGR formát |
| AMinKind / AMidKind / AMaxKind |
TXLSCfValueKind. Threshold types. Mid defaults to cfvPercentile / '50' — the classic "Red–Yellow–Green" Excel preset |
| AMinValue / AMidValue / AMaxValue |
WideString. Threshold literal text. AMidValue defaults to '50' to pair with cfvPercentile |
Príklad
This example colors A1:A10 with the classic Red-Yellow-Green scale
Sheet.AddCondFormatColorScale3('A1:A10',
$000000FF, $0000FFFF, $0000FF00);
Pozri tiež
Tento príklad sfarbí A1:A10 klasickou škálou Červená-Žltá-Zelená