Shading Band row based on change of value

[gnulab]

Hi,

I would like to achieve this without a helper column. Is that possible?


ve7L9.png


Thank you
Henry

[HansDouwe]

Please try Conditional Format rule: =MOD($A2,2)=1 applies to $A$2:$B$8

[gnulab]

Hi Hans,

The solution is applicable when column A is number. What if it is text value?
WhatsApp Image 2023-10-28 at 11.12.08_eeea5086.jpg

Sorry for not making it clearer.

[ORoos]

You could use a 'helper' column (which you can hide).
In cell "C1" enter 0 (zero)
In cell "C2" enter:

Please Login or Register  to view this content.

and pull down.

You now can use the conditional formatting rule from HandDouwe on the 'helper' column: =MOD($C1,2)=1 applies to $A$2:$C$20

[HansDouwe]

Please try Conditional Format rule: =MOD(ROWS(UNIQUE(A$2:A2)),2)=1 applies to $A$2:$B$10