Change drop down list color cell based on range of values

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

ok thanks. i have done it for one cell (A9) and it works. but now when i copy the conditional formatting created to the other cells of the column, the same rules do not apply. how can i do? do have i to rewrite the cell references for every cell in the column?

sorry i cannot attach a file. i attached two images more zoomed.

Immagine 2022-03-05 171710.jpg Immagine 2022-03-05 171738.jpg