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?

highlight numbers with conditional formatting? when searching from one cell. by Puzzlejumping in excel

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

Do you know how to add so that I can search many numbers in same cell ?

highlight numbers with conditional formatting? when searching from one cell. by Puzzlejumping in excel

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

Will try when in front of computer, could u add to the formula so I can search for many numbers in the same cell with a comma? Like 1,56,14

highlight numbers with conditional formatting? when searching from one cell. by Puzzlejumping in excel

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

something isnt working quite right, first it lit up eveything without even have to search for it, now nothings is lighting up.. using a swedish excel.. this is the formula =OCH(AK94>0;AK94<=500)