Conditional formatting cells, dependent on value in range and choice of drop down list

I have the below conditions i want my cells to relate to.

Picture1.jpg

I have a column with all my data in, and in the column next to it i have a drop down list for the severity, (1-6), which can change and I choose manually.

I want the cell with the data in to be formatted the same as the image. So if the value is in the range >=10E-4 to <10E-3, and I specify the severity is a 5, then my cell with data in goes yellow, and if its a severity of 6 then the cell becomes red, etc.

all ideas will be really helpful.

can you post an example spreadsheet rather than an image

I set something like this up recently for a project using a 1-6 scale horizonal and 1-6 vertical and use AND / OR


so

AND( cell >=10E-4, cell <10E-3, cell with severity =5 )
then yellow

then a new rule for red
AND( cell >=10E-4, cell <10E-3, cell with severity =6 )

Assuming that the info is in as attached spreadsheet

then formula I posted will work - see attached example

why 36 rules ?

can you combine into 1 set for each colour some how

can you post a few examples of RED