Home

Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-489406%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489406%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%2010%20paints%20numbered%201-10.%20Each%20number%20represents%20a%20different%20color%2C%20e.g.%201%3D%22RED%2C%202%3D%22ORANGE%22%20etc.%20How%20can%20I%20show%20the%20color%20name%20in%20one%20cell%20depending%20on%20the%20number%20in%20another%3F%3C%2FP%3E%3CP%3Ee.g.%20If%20A2%3D1%20then%20C2%3D%22RED%22.%20If%20A2%3D2%20then%20C2%3D%22ORANGE%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-489406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-489440%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489440%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328861%22%20target%3D%22_blank%22%3E%40tottieon%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20variant%20is%20to%20use%20formula%20like%20(expand%20it%20on%20all%20your%20colors)%3C%2FP%3E%0A%3CPRE%3E%3DCHOOSE(A1%2C%22RED%22%2C%22ORANGE%22%2C%22BLUE%22)%3C%2FPRE%3E%0A%3CP%3EAnother%20variant%20if%20you%20have%20texts%20with%20your%20colors%20in%20helper%20column%20(could%20be%20in%20another%20sheet)%2C%20let%20say%20in%20E1%3AE10%2C%20when%3C%2FP%3E%0A%3CPRE%3E%3DINDEX(%24E%241%3A%24E%2410%2CA1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490212%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490212%22%20slang%3D%22en-US%22%3E%3CP%3E10%20times%20conditional%20formatting%2C%20with%20formula%20determine%20the%20cell%20format%3C%2FP%3E%3C%2FLINGO-BODY%3E
tottieon
Occasional Visitor

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 Replies

@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)

10 times conditional formatting, with formula determine the cell format

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies