See attached.
auto_color_changing_to_a_range_of_integers.xlsx

I have a range B2:B11.
It is a ranking, so it contains each of the unique integer values 1 through 10.
It will always consist of this set, BUT order will vary based on user usage of the rest of worksheet.
I have a fixed set of 10 unique colors in A2:A11, each to a value in B2:B11.
I want a formula in each of B2:B11 that changes the fill color for B2:B11 in accordance with adjacent value in the cells in B2:B11
No VBA / macros please.
Conditional formatting is acceptable.
Thanks much!
J