{"id":7556,"date":"2017-11-07T10:34:02","date_gmt":"2017-11-07T09:34:02","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=6205"},"modified":"2017-11-07T10:34:02","modified_gmt":"2017-11-07T09:34:02","slug":"creer-une-liste-de-couleurs-alternees-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/create-an-alternated-colors-list-in-google-sheets\/","title":{"rendered":"Comment cr\u00e9er une liste de couleurs altern\u00e9es dans Google Sheets ?"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

When you’ve got a large dataset in\u00a0<\/span>Google Sheets<\/a>, it’s incredibly hard to read and navigate the spreadsheeet if every row and column looks the same. Breaking up your spreadsheet with colors and formatting is a simple way to give some visual structure to a large expanse of data. This will make it easier to read and find information, which is particularly important if others also need to use the spreadsheet. By default, spreadsheets are plain and simple, but luckily you can break up that huge sea of gray cells with an alternated colors list in Google Sheets. This function allows you to alternate row colors in a couple of clicks, throughout part or all of the spreadsheet.<\/p>\n

Creating an alternated colors list in Google Sheets<\/h3>\n

Take a look at the spreadsheet below. A customer service team use this file to track of issues reported by clients. The file is data-heavy and it contains a huge number of records:<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/alternated1.png” alt=”Alternated Colors List in Google Sheets” title_text=”alternated-colors-list” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Your eyes will struggle as you attempt to read through this volume of information on a screen. It’s easy to confuse one row for another and you may have to do a double-take. Ultimately this is really time-consuming so it\u2019s a productivity problem as well.<\/p>\n

The alternating colors functionality colors every other row in a darker shade, and keeps the other remaining rows in a contrasting, lighter, color. This is easier on the eyes and it makes it easier to read the data.<\/p>\n

I’ll show you this function applied to the previous spreadsheet.<\/p>\n

Go to\u00a0<\/span>Format > Alternating colors<\/strong>. A sidebar opens on the right-hand side of the screen:<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/alternated2.png” alt=”Navigation to Alternating Colors” title_text=”alternating-colors” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

You can apply alternating colors to a specific range, choose from predefined color palettes, or customize one to suit your preferences, such as colors that match your company branding. While you test out the options, Google gives you a preview of how it will appear in the spreadsheet.<\/p>\n

If your spreadsheet does not have a header, deselect the checkbox.<\/p>\n

When you’ve found the color combination you want, click the\u00a0<\/span>Done<\/strong>\u00a0<\/span>button.<\/p>\n

Here I’ve gone for a simple blue option:<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/alternated3.png” alt=”Alternated Colors Example in Google Sheets” title_text=”alternated-colors-example” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]

Tips<\/h3>\n