So I have a powershell script I wrote that exports to a csv file.  It works fine, but I want to be able to present it to more people and want the formatting a little better when opened with Excel.  Pretty much I just want to change the color of the text and make sure the spreadsheet is formatted, so I don't have to click to expand the cells.  Any thoughts on how this could be accomplished within powershell?  I can change the format of the file if needed, it does not have to a csv.

Thanks.

If you want fancy formatting you'll need to output to Excel files instead.

CSV files do not have formatting, sheets, etc.

Here's some background information to get you started:

http://blogs.technet.com/b/heyscriptingguy/archive/2014/01/10/powershell-and-excel-fast-safe-and-reliable.aspx

http://powershell.com/cs/blogs/tobias/archive/2010/08/19/automating-office-and-excel-in-powershell.aspx

http://learn-powershell.net/2012/12/16/powershell-and-excel-creating-your-initial-report/

Worth to give a shot with below module as well

https://github.com/dfinke/ImportExcel