Show Zebra Lines when Value Changes [Excel Conditional Formatting Homework]
Here is a quick home work on excel conditional formatting.
Lets say you have data as shown below to left and you need to show zebra lines whenever the value changes (see right).
Your home work is simple. Just figure out how to write conditional formatting rules to add zebra lines.
The data set is here.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Remove duplicates & sort a list using Pivot Tables||Excel School Closing in a Few Hours – Join Now!|