Forum Discussion
Josh_Waldner
Dec 04, 2021Brass Contributor
index
Hello, everyone I would like to find a way to index rows and columns depending on the color of the cells. place quantity of shaded cells may vary in the grid space. see the attached for more detail...
mtarler
Dec 05, 2021Silver Contributor
Josh_Waldner you can't do that but in the attached I created 2 alternatives using conditional formatting. In 1 option you add the cell coordinates in your lists and the corresponding cells in the grid will get colored. In the other option you type a letter like "b" for blue or "o" for orange into the grid which will cause that cell to get colored that color (and the letter is hidden) and then the list is created below based on that. (The formulas I used are based on Excel 365)