Home

Lookup and cell color shade identified 3 digit cell combination

%3CLINGO-SUB%20id%3D%22lingo-sub-369439%22%20slang%3D%22en-US%22%3ELookup%20and%20cell%20color%20shade%20identified%203%20digit%20cell%20combination%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369439%22%20slang%3D%22en-US%22%3EHello%2C%20community!%20Still%20new%20on%20Excel%2C%20please%20help%20me%20make%20command%20formulations.%20I%20have%20a%20continuing%20input%20of%203%20digit%20cell%20data%20of%20any%20combination%20from%200%20to%209%20having%2031%20rows%20and%20now%20at%20ff%20culumn%20data.%20Need%20to%20make%20command%20formulation%20as%20I%20need%20to%20search%206%20sets%20of%20cell%20data%20and%20to%20highlight%20with%206%20color%20each%20identified%20cell%20which%20contains%203%20digits%20in%20any%20order.%3CBR%20%2F%3ESay%2C%20command%20lookup%20123%20red%2C%20445%20green%2C%20067%20yellow%2C%20376%20orange%2C%20888%20blue%2C%20945%20violet.%20so%20I%20could%20easily%20see%20all%20datas%20color%20shaded...Can%20anyone%20provide%20the%20formulation%20of%20commands%3F%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulation%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
oghing
New Contributor
Hello, community! Still new on Excel, please help me make command formulations. I have a continuing input of 3 digit cell data of any combination from 0 to 9 having 31 rows and now at ff culumn data. Need to make command formulation as I need to search 6 sets of cell data and to highlight with 6 color each identified cell which contains 3 digits in any order.
Say, command lookup 123 red, 445 green, 067 yellow, 376 orange, 888 blue, 945 violet. so I could easily see all datas color shaded...Can anyone provide the formulation of commands?
Thanks