VB Code or Formula

[Vishaal]

pls provide code or formula for a sheet

link is https://drive.google.com/file/d/1PS_zvcTpLhqOpa6uclRsh0O-IS0Hvveg/view?usp=sharing

you can check the file so that all the points will be clear

we need two results

1. After how many rows the digit comes
2. Highlight the cell when the value comes and start again from here

 

[Vishaal]

@Vishaal
You will stand a better chance of getting help, if you tell us what you are trying to do.
A lot of members either cannot, or will not, download files for security reasons.
There are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that will enable you to post a small amount of sample data to the board

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

2​

[/td][td]we need to check the digit of row number 2,3 and 4 in next rows (Row No. 2,3,4 and value is 2,5,6 - we will check 2,5 and 6 from row no. 5 and when we get the any digit 2,5 and 6 we will highlight that row[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

5​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

6​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

8​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

9​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

3​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

5​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td=bgcolor:#FFFF00]

2​

[/td][td]We will again start the same thing from here, I mean we will check the digit 2,5 and 3 from row no. 10[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

6​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

7​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

9​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

6​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

4​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]

1​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]

4​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]

4​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td]

7​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

19​

[/td][td=bgcolor:#FFFF00]

2​

[/td][td]We will again start the same thing from here, I mean we will check the digit 2,7 and 4 from row no. 20[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

20​

[/td][td]

9​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

21​

[/td][td]

5​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

22​

[/td][td=bgcolor:#FFFF00]

4​

[/td][td]We will again start the same thing from here, I mean we will check the digit 4,5 and 9 from row no. 23[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

23​

[/td][td]

3​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

24​

[/td][td]

8​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

25​

[/td][td=bgcolor:#FFFF00]

9​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

26​

[/td][td]

​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

27​

[/td][td]

​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

28​

[/td][td]

​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

29​

[/td][td]

​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

30​

[/td][td]

​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

31​

[/td][td]We also need the report after how many row the digit comes, I mean in the above row answer is[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

32​

[/td][td]

​

[/td][td]After 5 row = 1 (You can check the digit of row no. 2,3,4 comes after five row and it is 2)[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

33​

[/td][td]

​

[/td][td]After 10 row = 1 (You can check the digit of row no. 9,8,3 comes after 10 row and it is 2)[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

34​

[/td][td]

​

[/td][td]After 3 row = 2 (You can check the digit of row no. 19,18,17 (Number are 2,7,4) which comes on row no. 22 & digit of row no.22,21,20 whic comes on row no. 25 after five row)[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

 

[Vishaal]

tried to post as you describe but its not looking good due to file is coming on full screen, well try to update a good file next time.

any solution.....