Conditional formatting

[tottieon]

I have 10 paints numbered 1-10. Each number represents a different color, e.g. 1="RED, 2="ORANGE" etc. How can I show the color name in one cell depending on the number in another?

e.g. If A2=1 then C2="RED". If A2=2 then C2="ORANGE".

[#2]

@tottieon ,

One variant is to use formula like (expand it on all your colors)

=CHOOSE(A1,"RED","ORANGE","BLUE")

Another variant if you have texts with your colors in helper column (could be in another sheet), let say in E1:E10, when

=INDEX($E$1:$E$10,A1)

[#3]

10 times conditional formatting, with formula determine the cell format