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
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Automatic coloring sunburst chart
stefan645 in Excel on
2 Replies
Linking Adjacent Rows
ashwinash112 in Excel on
1 Replies
Cell color
DaneeTewell in Excel on
0 Replies
Default Main Calendar Color and Legend
magicmike52014 in SharePoint on
0 Replies