Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction

[DocAElstein]

Hello Leonardo1234,
Welcome to excelfox
I have looked at your file, and read your request but I cannot understand quite your output requirement .??
You say …" compare each complete row of sheet2.."..here is your given Sheet2 from your file:

1 L 1	1 L 1,1 L 1
1 G 1	1 E 1	1 L 1,1 L 1	1 E 1
1 G 1	1 E 1	1 L 1,1 L 1	1 E 1	1 G 1
1 E 1	1 G 1

Worksheet: Sheet2
You say….." compare each complete row of sheet2 with sheet3 each complete row" … here is part of Sheet3 from your file:

1 L 1	1 E 1	1 L 1,1 L 1	1 G 1
1 G 1	1 E 1	1 L 1	1 L 1	1 G 1
1 L 1	1 L 1,1 L 1	1 L 1	1 G 1
1 L 1	1 L 1,1 L 1
1 L 1	1 G 1	1 E 1	1 L 1
1 G 1	1 L 1	1 L 1,1 L 1	1 L 1	1 L 1	1 G 1

You say … "compare each complete row of sheet2 with sheet3 each complete row and if sheet2 complete row match with sheet3.."…
OK so far so good, we see a match - ( 1 L 1 __ 1 L 1,1 L 1 = 1 L 1 __ 1 L 1,1 L 1 )

But here is the problem: You then say : " compare each complete row of sheet2 with sheet3 each complete row and if sheet2 complete row match with sheet3 complete row then highlight it with green colour in sheet4 in column B"…..
This is your Sheet4:

20abc
abc20
def
ghi

Worksheet: Sheet4
???
Are you attempting to say this:
Compare each complete row of sheet2 with each complete row of sheet3
If sheet2 complete row matches with sheet3 complete row then:
Highlight the row in sheet4 in column B corresponding to the row matched from Sheet2.

So in the shown example, the matched rows were row 1 in Sheet2 and row 4 in Sheet3.
So the column B row 1 is to be highlighted as the match from Sheet2 was in row 1

Please confirm that this is your requirement, or try to explain again
Thanks
Alan


P.S.
If I have guessed your requirement correctly, then I have another question:
Question on you: Is there a maximum number of columns that may be used. ?