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 changes, it can be just two colors, Truck could be blue, then Horse could be no color, Plane would be blue, next word would be no color, I just need something to differentiate each block when the text changes.
Thanks,
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 changes, it can be just two colors, Truck could be blue, then Horse could be no color, Plane would be blue, next word would be no color, I just need something to differentiate each block when the text changes.
Thanks,