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.
|Remove duplicates & sort a list using Pivot Tables||Excel School Closing in a Few Hours – Join Now!|