detect a color only spaces of a cell only.

detect a color only spaces of a cell only, example 12 13 14 12 14 has only one cell
macro only process with a range cell
https://www.excelforum.com/attachmen...1&d=1591275337

hello please!

ok alan, thanks for viewing the post,
let's go step by step, the macro, will mark in a color or another character, only where there is a cell range from one number to another
* example that you can't = 01 04 = note that here there are two spaces or two cells, the macro here doesn't register, another example 14 16 here has an interval or an interval cell, this yes the macro does, all two numbers where act a range cell the macro does =
* goal = is to see the range of a cell from one number to another, when it has more than two cells the macro does nothing

hello, alan, so the macro will only register a color number sequences where there is only one cell range

hello ALAN, please!

hello sintek, thanks for viewing the post, very first the macro detects, in the two lists the corresponding numbers, then the macro highlights in a color or another character, only intervals of a cell between two numbers, where there are intervals 2,3,4 no does
https://www.excelforum.com/attachmen...1&d=1591448796

hello, oh ok sorry, blue is the same pattern as red, I forgot to do it on the other list but where there's blue is red, it's the same pattern, it's all the same

ok where there is the (?) point there you have to go the color can be red or blue, you can do it even below, where will the (?) points be highlighted in a color

hello SINTEK BAH! , how wonderful, work of art, expended master's work, congratulations, thank you

hello SINTEK I reopened, to see if you can add in each the number of times the red pattern happened, ex = 5.6 or 4.6 ....
is to add in each row the number of times that the red pattern happened
objective is to assemble the suit = ex = 5.6 6.6 ....

? x x ? x x x ? x x x ? x x x x ? x x ? x 6 x ? x x ? x x x ? x x x x x x ? x x x ? 5

is to add the quantity of each line
example = 1st line had 6 red patterns the 2nd line had 5 red patterns, this gave a suit
6.5, if you can compile statistics on the number of times you were drawn
*

3,3 = exemplo=has already been drawn 49 times and an example
3,4
3,5
3,6
3,7
3,8
4,3
4,4
4,5
4,6
4,7
4,8
5,3
5,4
5,5
5,6
5,7
5,8
6,3
6,4
6,5
6,6
6,7
6,8
7,3
7,4
7,5
7,6
7,7
7,8
8,3
8,4
8,5
8,6
8,7
8,8

the list above are all the possibilities of suits 3 to 8
in 96% of the draws, amcro will see the frequencies in order to see which one is more drawn

but the 1st list is not adding up. the 2nd list is correct, you have to do it on the 1st list too to set up the suit

ok corret, SINTEK,perfect, conglatilations, thank you!!!