Fill a merged cell group a color based on value in another cell

[Wx4Mark]

Thanks for help in advance. I've found great info on this site before. I am not an excel expert by any stretch so this might be a simple answer - I hope so! I'm trying to fill a merged cell a specific color based on a number in another cell. It would step through some logic to determine the right color. In simple sense - this is what I'm trying to do:

	A​	B​	C​
	Threat Level	Probability​	Risk Level​
1​	none​		​
2​	low​
3​	medium​
4​	high​
5​	very high​

Probability can be an integer of 0 to 10
Risk Level is a merged cell group and has 5 color possibilities

I’d like C1:C5 to be filled according to this logic

IF B:5 > 4 THEN C1:C5 = <Black Fill> Else
IF B:4 > 4 THEN C1:C5 = <Red Fill> Else
IF B:3 > 4 THEN C1:C5 = <Orange Fill> Else
IF B:2 > 4 THEN C1:C5 = <Yellow Fill> Else
<Green Fill>

I've just not been able to get the formula right to accomplish this.

 

[Special-K99]

What happens if B2 is > 4 AND B3 > 4 ?
B2 > 4 says Yellow fill
but
B3 > 4 says Orange fill

Which should it be, the fill cant be both.

 

[Special-K99]

Select the range to highlight

Conditional Formatting
New Rule
Use a formula to determine...

5 rules, one for each colour

=B$5>4
fill as black

=B$4>4
fill as red

adjust formula and colour for the other conditions
etc

 

[Wx4Mark]

What happens if B2 is > 4 AND B3 > 4 ?
B2 > 4 says Yellow fill
but
B3 > 4 says Orange fill

Which should it be, the fill cant be both.

Thanks for your response, the logic is prioritized so if the first is "true", then it would stop - otherwise progress down and stopping only when "true".