I have a spreadsheet with multiple columns. For some of the columns I need to look at each set of 2 rows, and highlight the sets where the values are different. For example, this is what my column needs to look like:
23000101
23000101
20090701
20110701
23000101
23000101
23000101
23000101
20090819
20110819
23000101
23000101
Is there any way to do conditional formatting using formulas to do this, or any other way?
Bookmarks