New Row Formatting

[Chris1201]

I have a userform set up to create a new row on a worksheet and enter data that was filled out on the work sheet. Some of the data comes from text boxes which put in name, rate, division, received date, and loss date. The other info is taken from checkboxes and designed to put either an X or N/A, or just leave a column blank.

Basically, what I want to do is figure out, when I make a new row, how to format that row to have borders around each cell, make columns 6-29 bold, and the cells in columns 6-29 colored with a gray background.

If you need a dummy worksheet to better describe what I'm looking for, let me know. I haven't made one up yet.