Home

Look up and color fill cells identified when conditions are met

%3CLINGO-SUB%20id%3D%22lingo-sub-376063%22%20slang%3D%22en-US%22%3ELook%20up%20and%20color%20fill%20cells%20identified%20when%20conditions%20are%20met%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376063%22%20slang%3D%22en-US%22%3ENew%20excel%20user.%20Im%20using%20Excel%20on%20my%20daily%20tabulations%20of%203digit%20lotto%20results%20on%20each%20cell%20which%20may%20include%20double%20or%20tripple%20digit%20from%200%20to%209%20(%20ex%3A%20022%2C%20777%20).%20Datus%20now%20on%20constant%2031%20rows%20and%20up%20column%20ff%20on%20continuous%20input%20of%203%20digit%20each%20cell.%20At%20any%20single%20time%2C%20I%20need%20to%20look%20up%206%20sets%20of%203%20digit%20cell%20combinations%20into%20which%20I%20need%20to%20color%20fill%20cells%20that%20met%20conditions%20upon%20command%20criteria.%20Example%3A%20Lookup%20and%20color%20fill%20cells%20containing%20in%20any%20order%2C%20247%20yellow%2C%20076%20green%2C%20288%20blue%2C%20193%20orange%2C%20555%20violet%2C%20657%20red.%20Please%20help%20me%20make%20command%20formulation.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-376063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
oghing
New Contributor
New excel user. Im using Excel on my daily tabulations of 3digit lotto results on each cell which may include double or tripple digit from 0 to 9 ( ex: 022, 777 ). Datus now on constant 31 rows and up column ff on continuous input of 3 digit each cell. At any single time, I need to look up 6 sets of 3 digit cell combinations into which I need to color fill cells that met conditions upon command criteria. Example: Lookup and color fill cells containing in any order, 247 yellow, 076 green, 288 blue, 193 orange, 555 violet, 657 red. Please help me make command formulation.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies