Zebra Stripes
Tessel75
Posted messages
198
Status
Member
-
chossette9 Posted messages 6855 Registration date Status Contributor Last intervention -
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
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
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,
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,
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 ♂
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
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.
As I pointed out here https://forums.commentcamarche.net/forum/oldest/4034675-couleur-differente-une-ligne-sur-2-dans-excel?full#24, we use automated formats; we can, at best, only take advantage of the options available ...
Fortunately, there are quite a few, including for colors!
Fortunately, there are quite a few, including for colors!
