Excel similar or comparison between two sheets and color row

Excel similar or comparison between two sheets and color row I would like to compare two sheets (sheet1 and sheet2), and color a compleet row in sheet2 when for example 1 or more the same numbers are found in sheet1,
Asked by: Guest \| Views: 251

Total answers/comments: 1

Comments display order:

Guest [Entry]

"Suppose you are interested only in the first 100 rows. Then:

define the following name: int2 for Sheet2!$A$1:$A$100
define for cells
A1:A100 in Sheet1 the following
formula for conditional format:
=SUM(--(ISERROR(MATCH($A$1:$A$100,int2,0))=FALSE))>0"