excel2003 按颜色排序
EXCEL2003按颜色排序:
颜色单元格在A列,选中B1,插入-定义-名称(快捷方式:ctrl+f3),输入a,下面输入公=get.cell(24,$a1),此法可得到字体色的序列号B1输入=a 若是想获得背景色序列号,将2
即可
backcolor fontcolor
G#NAME?#NAME?
T#NAME?#NAME?
G#NAME?#NAME?
H#NAME?#NAME?
D#NAME?#NAME?
S#NAME?#NAME?
Y#NAME?#NAME?
S#NAME?#NAME?
F#NAME?#NAME?
J#NAME?#NAME?
D#NAME?#NAME?
H#NAME?#NAME?
F#NAME?#NAME?
T#NAME?#NAME?
A#NAME?#NAME?
),输入a,下面输入公式
得背景色序列号,将24改成63
相关主题