Hello all,
I was trying to auto filter in Excel with color. The color index of interior object is 6 (yellow)
So far the script is as below. Help please?
tell application “Microsoft Excel”
tell active sheet of active workbook
set x to get color index of interior object of cell “A1”
–autofilter range range “A1:D1” field “1” criteria1 x
autofilter range range “A1:D1” field “1” criteria1 color index of interior object “6”
–range range “A1:D1” field “1” criteria1 x
end tell
end tell