Jun 19 2019 08:03 AM
...
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.
Note Excel says "This workbook cannot be shared because it contains Excel tables" so Excel Tables are out when using a Shared Workbook.
What do you think?
How can one alternate row colors in a SHARED WORKBOOK in Excel 2013?
Please advise.
Thanks.
-- Mark Kamoski
...
Jun 19 2019 08:20 AM
Hi Mark,
You may apply conditional formatting rule to your range with formula
=MOD(ROW(),2)=1
Jun 19 2019 09:19 AM
Jun 19 2019 09:45 AM
Oops, sorry, I forgot conditional formatting doesn't work on shared workbooks. As workaround you may add helper column with the similar formula, apply filter to your range together with this helper column, filter rows with 1 (or zero) in it, apply color to filtered rows, remove filter
Jun 20 2019 08:25 AM
Jun 20 2019 08:38 AM
Mark - yes, after inserting / adding rows manual adjustment will be required. If only for adding you may color your range with some gap. Or color another empty sheet as much as needed and apply format from it by Format Painter when the range changes. Another variant is write some macro.