Posted to microsoft.public.excel.newusers

nishkrish

external usenet poster

Posts: 31

compare worksheets

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.

--
Nisha P

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to compare 2 worksheets...	Bonnie	Excel Discussion (Misc queries)	3	December 2nd 08 11:06 AM
Compare Worksheets	dahench	Excel Discussion (Misc queries)	2	March 3rd 07 02:29 PM
compare worksheets	klafert	Excel Discussion (Misc queries)	6	January 15th 07 02:17 AM
Compare worksheets	praveen_khm	Excel Worksheet Functions	0	January 17th 06 05:54 PM
Compare Two Worksheets	Jim	Excel Discussion (Misc queries)	1	October 11th 05 08:51 PM

All times are GMT +1. The time now is 05:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us