How to apply theme color of cell in excel using apple script

Question

I am using Apple script. My problem is, how can i change the theme color of cells to first accent theme color.

tell interior object of cell "A1" set color index to 5 set theme color 9 end tell

In this script color index is set but theme color is not set . Please help me. i am waiting for your replay.

Thanks

Answer 1

Try:

tell application "Microsoft Excel" to set theme color of interior object of cell "A1" to first accent theme color