Conditional Format help

[Billnomind]

I need cell B8 to change its fill between two colors according to what number is being read in cell F8.
Cell F8 will have a number chosen by a set list by manual input. depending on the number I need it to choose a specified color.

 

[bebo021999]

B8 has no color, F8 is blank, at the moment.
If F8 is filled with number, which number for which color?

 

[Billnomind]

B8 has no color, F8 is blank, at the moment.
If F8 is filled with number, which number for which color?

If F8 = 454,455,545,461,460,459,458,457,456,12,462,463,464,465,466,467,468,469 then I need B8 to be orange
If F8 = 1,2,3,4,5,6,7,8,30,51,38,41,42,601,6011,6012,602,65 then I need B8 to be red
If f8 has no value than B8 needs to have no fill

 

[bebo021999]

So, conditioning formating formula in cell F8:

Orange
=OR(AND(F8>=454,F8<=469), F8=545,F8=12)

Red
=OR(AND(F8>=1,F8<=8), F8=30, ......)

Its better to create a lookup table, input all numbers then using COUNTIF to check