compare worksheets

N

nishkrish

Hi ,

can someone help me with this i went to window menu and clicked compare side
by side it works but i want to show the result if a certail cell of a row
doesnt match or highlight it so i know its different i even tried formula but
it doesnt work
=if(i2=v2,"1","0") but it show 1 all over.


please help ASAP.
 
G

Gord Dibben

If I2 and V2 are in separate workbooks.

Your formula in Book1 should read like this..........

=IF([Book2.xls]Day!$B$1=B1,1,0)


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Macro for comparing columns and highlighting matching/differences 13
Conditional Formatting Based On Formula Values 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
how to compare formula's values? 4
Drop down list control value in vba 2
Paste Options Icon does not show 0
check first 3 characters of a cell and compare to a table 4

Top