I want my spreadsheet to automatically generate alternating colors based on row header change, like the image below.
Ideally without creating auxiliary columns or macro/scripts (which I can create myself but don't want to). The length of the table is variable and the table is dynamic.
I've tried to create some magic logic with conditional formatting, but while I can create logic that identifies a row header changes (using the
=(A3=A2) logic, I could not find a way to identify to color of the previous row. So the answer to the question on how to (using formulas and no script) identify the background color of a determined cell could be helpful as well.