View original (French)

Zebra Stripes

Tessel75 Posted messages 198 Status Member -  
chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   -
Hello,
Is there a button in Excel like in Access to color every other row or every other column in a table? I've looked but haven't found anything. Thank you.

Configuration: Windows 7 / Chrome 23.0.1271.97

3 answers

  1.
    pilas31 Posted messages 1878 Status Contributor 648
     
    Hello,
    It all depends on the version of Excel.
    Starting from version 2007, you need to use the "Format as Table" function in the "Home" tab.
    For earlier versions, you need to use conditional formatting as shown in this discussion:
    see the solution suggested by eriiic

    --
    Best regards,
    0
  2. Raymond PENTIER Posted messages 58230 Registration date   Status Contributor Last intervention   17 498
     
    You can also do Insert/Table: by default, it is created with alternating rows. But with Table Tools/Design/Table Style Options you can alternate the columns ...

    --
    Retirement is great! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    0
  3. Tessel75 Posted messages 198 Status Member 22
     
    Thank you for your response; I do have the 2007/2010 version. I tried it, but I thought there was something else with which we could choose our color. Thank you again.
    0
    2. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      Hello,

      the first response from the link provided by Raymond (response from eriic) should help you do what you want (every other column or every other row).

      Best regards.
      0