I am new to Applescripts and Excel 08? I want to write one that colors arbitrarily preselected cells in Excel 08 specific colors. I can get it to write want in an preselected cell and even bold the font...but for some reason it will not change the color of the cell...
print("Tell application "Microsoft Excel"
activate
set formula of active cell to "excellent answer"
set bold of font object of active cell to true
activate cell active cell");
This part doesn't work for some reason`
print("tell interior object of active cell of active sheet
set color index to 3
set pattern to pattern gray 50
set pattern color index to 13
end tell");
not sure why