If I create an Excel table object with Powershell and use it to insert a row into the table like
$Table.ListRows.Add()
It formats the new row like the row above it. If the row above has been filled with grey, it will be filled with grey, for example. If I use the GUI and tab past the last column of the last row, it adds a new row, but it is formatted like the default for the table style in use (with banded rows, for example). How can I use Powershell to get that format applied? (color and text formatting)