hello.
I have an Excel sheet used to record working hours for some projects. I am trying to change the cell color of the dropdownlist cell in column "A" based on the color of a range of cells in BP2:BP14 where I write the names of the projects I work on, where every project has a different color. I'd like the dropdownlist cell, i.e. A9, to have the same color of the project cell (i.e. a = yellow, etc.). Is it possible with conditional formatting or do I need to use VBA?
Immagine 2022-03-05 115056.jpg
Bookmarks