$$Excel-Macros$$ Duplicate colmuns

2009-07-23 Thread Rajesh Pal
hi Plz find attached the possible solution based on my understanding of the problem. The solution uses the following logic: =SUMPRODUCT(($C$2:$C$15=$B2)*1)>0 conditional formatting in B2 to B15 =SUMPRODUCT(($B$2:$B$15=$C2)*1)>0 conditional formatting in c2 to c15 Let me know if this was f

$$Excel-Macros$$ Duplicate colmuns

2009-07-22 Thread Mahesh
Hi All, Need a solution here. attached is the sheet contain data in Column B &C. What i need is, if the data in both column are same then it will be highlighted. Example:- 1 12N0044 076E5920 2 12N0648 076E5920 3 12N0650 076E4039 4 12N0650 076E4039 -- With Love, Mahesh Bisht --~--~-