formatting columns

[Jagadeeshbs]

Hello all


I want to compare 2 columns from 2 different sheets, if the values form column M= column S(other sheet) match no color if the value is not equal I want to change the color.

Please help me with this regard.


Thanks

Jagadeesh B S

 

[Luke M]

On other sheet, define column S as a named Range (e.g., MyList). Then, on first sheet,


Next, I'm not sure whether you want to just check if value form col M in in Col S, or if it's an exact row match...here's the former:

the conditional format formula is:

=ISNUMBER(MATCH(M2,MyList,0))


latter:

=M2=INDEX(MyList,ROW(M2))

 

[vasim]

You can give reference of S column(other sheet) on your existing sheet any column and use conditional formatting.........