Google Sheets Alternate Row Color by Unique Sorted Names

by Nowak   Last Updated November 23, 2017 23:03 PM

Background

I have a sheet that is sorted by Country Names, all unique Country Names are associated with more than one City.

Question

How do I alternate the color of every other Country Name, such that I can more easily distinguish which Cities belong to which Countries?



Related Questions


Conditional If Formatting Based on Two Columns

Updated February 04, 2018 22:03 PM

How to use AND in Google Sheets w multiple criteria

Updated March 12, 2018 20:03 PM

Conditional Formating in Google Sheets

Updated April 07, 2018 20:03 PM