How can I make my own format for MS Spreadsheet?

Question

Im trying to shade every other row to make it easier to read and Im sure theres another way than shading each row individually. What a pain.

Answer 1

From our friends at MS:

There are two approaches to shading (also called banding) alternate rows: automatic formatting and conditional formatting.

Using automatic formatting
The simplest approach is to choose one of the following pre-defined autoformats:

List1 shades every other row by using the Gray-25% fill color.
List2 shades every other two rows by using the Light Green fill color.
Use this approach after you complete your worksheet. If you update, filter, or sort the data later, you will need to re-apply the autoformat.

Shade alternate rows by applying an autoformat
Select the range you want to format.
On the Format menu, click AutoFormat.
Click the preview image of the List1 or List2 autoformat.
If you don't want to apply all aspects of the autoformat, click the Options tab, and then clear the check boxes for the types of formatting you don't want.
For more information on autoformatting, see Apply or remove automatic formatting on a range of cells.

Using conditional formatting
If you want more flexibility, you can apply conditional formatting to a range of data. By creating a custom formula that combines the MOD and ROW functions, you can specify which rows to shade, how many rows to alternate, and which color or pattern you want to use.

This approach is dynamic. If you update, filter, or sort the data, the formula preserves the alternating format you chose for that range.

Answer 2

try out a couple of the pre-made formats and then adjust one that you like or another option is to format a couple rows ant then copy and paste the format to the other rows

Answer 3

Shade 4 rows in the pattern you want. then highlight all of them and drag down. It should apply the pattern for you.

Answer 4

Click Format, and AutoFormat and select the one that looks best.