Forum Discussion
mkamoski
Jun 19, 2019Copper Contributor
How can one alternate row colors in a SHARED WORKBOOK in Excel 2013?
... Excel Folks, Please help. How can one alternate row colors in a SHARED WORKBOOK in Excel 2013? Please advise. Note this is a SHARED WORKBOOK so one cannot have an Excel Table...
SergeiBaklan
Jun 19, 2019Diamond Contributor
Hi Mark,
You may apply conditional formatting rule to your range with formula
=MOD(ROW(),2)=1