Excell for mac. insert rows with formatting from previous rows

broken image

This seemed really annoying, and so conditional formatting seemed less than useful. However, I was often confused about how to apply per-row conditional formatting to the whole table. It’s a great way to highlight critical pieces of information, provide quick visual distinctions, etc. I really appreciate conditional formatting in Excel. How to: Apply Per-Row Conditional Formatting across rows in Excel 2013