Zebra striping based on cell contents in Google Spreadsheets

If you're like me and love the power of spreadsheets but don't miss Excel one bit, this new feature has been a welcome addition. Truth to be told, it should have been added years ago. But it's here now so let's see what we can use it for.

What conditional formatting is

With conditional formatting, a cell's appearance can reflect its contents. In the past, Google spreadsheets could be used to format cells based on whether a cell's value was higher or lower than what was specified, equal, empty et c. With formulas, this feature becomes considerably more powerful.

Welcome to my blog. My name is Jakob Persson and I'm an entrepreneur and consultant. I work with companies to create measurable change by focusing on users, customers, market strategy and pricing. I'm a deep and broad specialist-generalist with skills in business strategy, digital marketing, pricing, interaction and service design as well as project management and software development.

This is my personal blog where I write on topics that interest me such as design, value-based pricing, marketing and technology but also on personal interests.

I am the founder of Leancept which makes companies more competitive through value-based pricing and customer intimacy.

Follow me on Twitter to get updates and links that I share.

If RSS is your preferred way of reading blogs, check out the RSS feed.

See the contact page for how to get in touch with me.