Thanks a lot for the fast reply.
Please note that in each cell in the range I will choose a one value only of the 30 values existing in the drop down list I've created.
Please check this example in this document
https://www.dropbox.com/s/3iryky9kyu...rmat.xlsx?dl=0

conditional format.xlsx