I need to color code a group of cells every time a value changes.
For example, in column A, I have the word Truck in the first 5 cells, then the word Horse in the next 5 cells, then the word Plane in the next 8 cells, etc.
I need a formula to color cod each group of cells whenever the value...