Hi
I want to conditionally format a cell based on value of another cell, details:

If cell A1 = 1, conditionally format cell B1
fill red if <9
fill yellow if 9-12
fill green if >12

If cell A1 = 2, conditionally format cell B1
fill red if <15
fill yellow if 15-16
fill green if >16

If cell A1 = 3, conditionally format cell B1
fill red if <17
fill yellow if 17-20
fill green if >20

If cell A1 = 4, conditionally format cell B1
fill red if <21
fill yellow if 21-22
fill green if >22

If cell A1 = 5, conditionally format cell B1
fill red if <23
fill yellow if 23-26
fill green if >26

If cell A1 = 6, conditionally format cell B1
fill red if <27
fill yellow if 27-30
fill green if >30


would appreciate any help, Thanks
rebecca