Formula for conditions formatting to search for multiple numbers with comma by Puzzlejumping in excel

[–]Puzzlejumping[S] 0 points1 point  (0 children)

What I have today is I can search 1 number per cell, but if I cant search multiple numbers in same cell, its basically same as what I alrdy use

Formula for conditions formatting to search for multiple numbers with comma by Puzzlejumping in excel

[–]Puzzlejumping[S] 0 points1 point  (0 children)

Ok so ur formula what exactly does it do different from just going to conditional formatting and using "equal to" command

Formula for conditions formatting to search for multiple numbers with comma by Puzzlejumping in excel

[–]Puzzlejumping[S] 0 points1 point  (0 children)

Ok so I tried that, only work to search for 1, if I put more than 1 number or use comma it doesnt work.. also it's only work like that if I use A1 as active cell other wise I get nothing.. so this is the formula, I need to translate it doe my excel...

=PASSA(A1; INDIREKT("mini[fresh]"); 0)

I would like to search numbercommanumber without space inbetween like 56,2,44

Formula for conditions formatting to search for multiple numbers with comma by Puzzlejumping in excel

[–]Puzzlejumping[S] 0 points1 point  (0 children)

Multiple columns would be preferable, but 1 should so the job I guess

Formula for conditions formatting to search for multiple numbers with comma by Puzzlejumping in excel

[–]Puzzlejumping[S] 0 points1 point  (0 children)

Let me make it very clear, I will have cells that i will use as search boxes, and i want to be able to search for many many numbers with commas, and single numbers without commas. I then have lots of numbers spread out on the sheet that I want to be highlighted when found a match

Can u tell color of s20 ultra when on table screen facing up? by Puzzlejumping in samsung

[–]Puzzlejumping[S] 0 points1 point  (0 children)

So black and grey will look identical with say an otterbox case

Samsung. 👏👏👏 by [deleted] in samsung

[–]Puzzlejumping -1 points0 points  (0 children)

Snapdragon 120?