Then in the Styles group , click on the Format as Table drop-down and select New Table Style at the bottom of the list. Then change the Stripe Size to 2. Click on the Format button. Click on the Fill tab and select the color for the shaded rows. In this example, we have selected a yellow.
Click the OK button. When you return to the spreadsheet, click on the Format as Table drop-down in the Styles group again and select the new customized style that you just created. Do the job yourself, using conditional formatting. Conditional formatting lets you apply formatting based on the value contained in a cell or based on the result of a formula.
There you have it: a table with banded colors. The real beauty of this method is that even if you delete a row in your table, the banding will be maintained automatically. Conditional formatting is applied to a cell when the condition you specify is true. For example, you could set all cells containing negative values to be displayed in a red font. The ROW function returns the number of the row contained in reference or, if the reference is omitted as in our example it returns the number of the row containing the function.
The MOD function returns the remainder of the number divided by the divisor. In English, we divide the current row number by 2. The template is automatically placed in the Templates folder to make sure that it will be available when you want to use it to create a new workbook. In the New dialog box, under Personal Templates , click the template that you just created. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you!
Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions.
Too technical.
0コメント