Conditional Formatting

Question

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?

sekoleyte · Answer

Faust25&nbsp;&nbsp;Hi there.&nbsp;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.&nbsp;It works as you said but no need to put an extra column.&nbsp;=ISODD(COUNTA(UNIQUE($B$3:$B3)))&nbsp;&nbsp;I share the file with you as well.&nbsp;&nbsp;

faust25 · Answer

Faust25&nbsp;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"