conditional formatting -Compare

[bines53]

Hello friends,

I need help with the tests I do,

I want to compare the second line with the next 3 lines, and so on, how can I put a

line in a formula and get the test of the next 3 lines?

Thank you !

David

 

[NARAYANK991]

Hi ,

You have highlighted those numbers in rows 3 , 4 and 5 which match the numbers in row 2.

What about the next step ? Will numbers in row 4 which match numbers in row 3 also be highlighted ?

You have given exactly one example ; can you give at least 3 or 4 examples ?

Narayan

 

[bines53]

Hi Narayan,

Good to hear from you !

"which match the numbers in row 2" -All the numbers appearing in the second row.


"What about the next step" -Compare the data in row 3, with the data in rows 4, 5, and 6.

Ie ,when I specify in formula 3, it should Compare in 3 consecutive rows, 4, 5, 6.

I attach another file,

Normally it should be,

--ISNUMBER(MATCH(INDEX($A$2:$E$11,N(IF(1,ROW($A$1:$A$3)+1)),N(IF(1,COLUMN($A$1:$E$1)))),INDEX(A2:E11,1,0),0)),

--ISNUMBER(MATCH(INDEX($A$2:$E$11,N(IF(1,ROW($A$1:$A$3)+2)),N(IF(1,COLUMN($A$1:$E$1)))),INDEX(A2:E11,2,0),0)),

And so on,


Thank you !

David