Hello! I'm trying to figure out how to find a way to automatically alternate rows between white and grey, depending on the text that is written in the first column of the sheet. Basically, when there text in the first column that is consecutively the same, I want the row color to match for those rows (grey). Then in the next row where the text changes to something else, I want that to be another color (white). When the text changes to something else in the next row, it would change back to the original color (grey). Etc, etc, etc. I have attached an image of what I want it to look like. Right now I filled in the cells manually, but I want to be able to do this automatically, so that it automatically updates when I add rows in random places. Thank you!
Capture.JPG
Bookmarks