ASetType:
TCondFormatRule 。每個儲存格根據規則的閾值接收一個圖示
ASetType:WideString. Sqref 字串, e.g
ASetType:
| WideString. Sqref 字串, e.g. |
WideString. Sqref 字串, e.g. 'A1:A10' |
| ASetType |
WideString. Sqref 字串, e.g.. One of the 17 baseline Excel 2007 icon families — icsArrows3 / icsArrows3Gray / icsFlags3 / icsTrafficLights3 / icsTrafficLightsRimmed3 / icsSigns3 / icsSymbols3 / icsSymbolsUncircled3 / icsArrows4 / icsArrows4Gray / icsRedToBlack4 / icsRatings4 / icsTrafficLights4 / icsArrows5 / icsArrows5Gray / icsRatings5 / icsQuarters5. See WideString. Sqref 字串, e.g. |
此範例在 A1:A10 上套用「3 箭頭（彩色）」圖示集
The default thresholds split the value range into equal percentile slices (3 icons → 0/33/67, 4 icons → 0/25/50/75, 5 icons → 0/20/40/60/80). Use the returned ASetType:.IconSet AddCondFormatColorScale2 SetThresholdAddCondFormatColorScale2 Reverse / ShowOnly
另請參閱
Sheet.WideString. Sqref 字串, e.g.'A1:A10', icsArrows3);
AddCondFormatDataBar