a******7
发帖数: 11 | 1 问下：
想用imagesc把matrix 画出来，但是imagesc的colorscale range > 0,
用 imagesc(matrix, [-1.0,1.0])，画的正负值一个颜色，怎么办？
应该是个菜问题，但就是不会
谢指教！ |
|
V******n
发帖数: 881 | 2 【 以下文字转载自 CS 讨论区 】
发信人: VAMclean (Mclean), 信区: CS
标 题: can anyone help me with a vba code? (you bao zi)
发信站: BBS 未名空间站 (Fri Jan 10 16:48:07 2014, 美东)
Sub Testing()
' Fill a range with numbers from 1 to 256.
Dim rng As Range
Set rng = Range("BF4:BF256")
Range("BF4") = 1
Range("BF5") = 2
Range("BF4:BF5").AutoFill Destination:=rng
' Add a 2-color scale.
Dim cs As ColorScale
Set cs = rng.FormatConditions.AddColorScale(ColorScaleType:=2)
' Format the ... 阅读全帖 |
|
V******n
发帖数: 881 | 3 Sub Testing()
' Fill a range with numbers from 1 to 256.
Dim rng As Range
Set rng = Range("BF4:BF256")
Range("BF4") = 1
Range("BF5") = 2
Range("BF4:BF5").AutoFill Destination:=rng
' Add a 2-color scale.
Dim cs As ColorScale
Set cs = rng.FormatConditions.AddColorScale(ColorScaleType:=2)
' Format the first color as red
With cs.ColorScaleCriteria(1)
.Type = xlConditionValueLowestValue
With .FormatColor
.Color = vbRed
... 阅读全帖 |
|
a******7
发帖数: 11 | 4 刚求证了，the expression below is correct.
do not bother any more.
thanks |
|
