Hello,

I would like to use either conditional formatting, a macro or another method to make a cell(s) turn a specific color based on what number is in a specific cell. An example would be if cell D3 = 1, 13, 25, 37, 49, 61, 73, 84, 97, 109, 121 or 133 then turn cells C and D BLUE. I need this for 12 colors.

List:

if cell D3 = 1, 13, 25, 37, 49, 61, 73, 84, 97, 109, 121 or 133 then turn cells C and D BLUE. (EACH NUMBER IS UNIQUE TO EACH COLOR)

if cell D3 = 2, 14, 26, 38, 50, 62, 74, 85, 98, 110, 122 or 134 then turn cells C and D ORANGE.

if cell D3 = 3, 15, 27, 39, 51, 63, 75, 86, 99, 111, 123 or 135 then turn cells C and D GREEN.

if cell D3 = 4, 16, 28, 40, 52, 64, 76, 87, 100, 112, 124 or 136 then turn cells C and D BROWN.

if cell D3 = 5, 17, 29, 41, 53, 65, 77, 88, 101, 113, 125 or 137 then turn cells C and D SLATE.

if cell D3 = 6, 18, 30, 42, 54, 66, 78, 89, 102, 114, 126 or 138 then turn cells C and D WHITE.

I would like to use either conditional formatting, a macro or another method to make a cell(s) turn a specific color based on what number is in a specific cell. An example would be if cell D3 = 1, 13, 25, 37, 49, 61, 73, 84, 97, 109, 121 or 133 then turn cells C and D BLUE. I need this for 12 colors.

List:

if cell D3 = 1, 13, 25, 37, 49, 61, 73, 84, 97, 109, 121 or 133 then turn cells C and D BLUE. (EACH NUMBER IS UNIQUE TO EACH COLOR)

if cell D3 = 2, 14, 26, 38, 50, 62, 74, 85, 98, 110, 122 or 134 then turn cells C and D ORANGE.

if cell D3 = 3, 15, 27, 39, 51, 63, 75, 86, 99, 111, 123 or 135 then turn cells C and D GREEN.

if cell D3 = 4, 16, 28, 40, 52, 64, 76, 87, 100, 112, 124 or 136 then turn cells C and D BROWN.

if cell D3 = 5, 17, 29, 41, 53, 65, 77, 88, 101, 113, 125 or 137 then turn cells C and D SLATE.

if cell D3 = 6, 18, 30, 42, 54, 66, 78, 89, 102, 114, 126 or 138 then turn cells C and D WHITE.