You may find that using Search or Super Search is a handy way to obtain answers to questions like this. There are a wealth of threads on precisely this point...
For starters, consider Formatting Excel cell using Perl and Using Win32::OLE and Excel - Tips and Tricks