Column random colour format

Is there any way to set conditional formatting or any other method to randomly change the cell colour as the text heading changes each time looking down the list.

I am basically looking for an auto method of changing the cell appearance as the text changes as per example, colours are not important and if easier could just alternate from say dark to light where there is a change
Random 03.png


Many thanks

For example, let's say your values are in range B2:B24.

Add a helper column adjacent to your values: In C2, enter formula:

Formula:

Please Login or Register  to view this content.

and fill down.

Now apply conditional formatting to range B2:B24, using formula:

Formula:

Please Login or Register  to view this content.

and format (fill) to suit. This will alternate between the default fill colour, and the conditional fill colour, based on grouped values in column B.

See worked example, attached.