Conditional Formatting

[Faust25]

In this table I want to highlight / change the colors of the rows (from Column ("A,B,C")when from Column "A" changes its values - example from column "A" all the rows that has "Apple" in them will highlight it in a different color, then the next from "Boy" it wont have any color changes but on the "Cat" will have the same color change as the "Apple" - so that will happen when every change of values from Column "A" happens - is it possible?

[#2]

@Faust25 

Managed to do it by adding number based on unique values from Column "A" and putting isodd function on conditional formatting but now I want to learn how to put a number sequence based on the changes of values on Column "A"

[#3]

@Faust25 

Enter 1 in A3.

In A4, enter the formula

=A3+(B4<>B3)

Fill down from A4.

[#4]

Oh my goodness! thank you this helps a looooooot

[#5]

@Faust25 If anyone wants the end results: here is the file

[#6]

@Faust25 

Hi there.

If you have office 365, UNIQUE function can be useful instead of adding extra columns. I don't like to use extra columns to do something. i always prefer base data to do it.

It works as you said but no need to put an extra column.

=ISODD(COUNTA(UNIQUE($B$3:$B3)))

I share the file with you as well.