'双色刻度
Sub sskd(rng As Range)
Dim cs As ColorScale '色阶条件格式规则
rng.FormatConditions.Delete
Set cs = rng.FormatConditions.AddColorScale(ColorScaleType:=2)
'最小值
With cs.ColorScaleCriteria(1)
.Type = xlConditionValueLowestValue
.FormatColor.Color = RGB(167, 217, 113)
End With
'最大值
With cs.ColorScaleCriteria(2)
.Type = xlConditionValueHighestValue
.FormatColor.Color = RGB(250, 191, 143)
' .FormatColor.TintAndShade = 0.4 '避免太亮,设阴影深浅
End With
End Sub