Jack-P-Winner
Member
How can I highlight consecutive numbers like 4-5 within a spreadsheet of 1000 rows? I have tried using a formula in conditional formatting and could not get it to work Lets say it stars in B:5
Thanks
Thanks
it's unclear why you have the range B6:D6 as 2 consecutive since from other example seems it should be 3 consecutive.
But have a look , below I did formulas returning trues and falses, 2 consecutive its not yet done because I would need specification about this range to know exact rules.
Hi there Narayan, I did no think of all the different combos for this. I will color ode them myself of course, I am basically wanting to find the different combos and color code them and if I miss some it no big deal. I will have to go back in and manually clear the formatting on strings like 123 and make them all one color. If I can pull out doubles example: 11 , Triples 111 and consecutives example: 12 123 1234 I will be tickled pink. Does this make sense? I know I will have to do some manual adjustmentsHi Larry ,
Still some doubts :
How would the following sets of 4 digits be coloured ?
1 ...... 7 ...... 2 ...... 8
1 ...... 7 ...... 1 ...... 7
1 ...... 1 ...... 3 ...... 2
3 ...... 1 ...... 2 ...... 3
We can think of many more such examples , but can you clarify what the results should be for these 4 examples ?
Narayan