View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jules Jules is offline
external usenet poster
 
Posts: 86
Default Comparing two worksheets

Greetings!

I have two worksheets, one is an old database and the other a newer updated
version of the old.

So far, I have named the range in the old and have applied conditional
formating to the new using a countif(myrange,a2)=0 to highlight the
differences. The conditional formating is making the spreadsheet difficult
to work with, its very sluggish...one question is: Can I copy and past the
new formating without losing the marked differences or do I need to keep the
conditional formating? another question would be - - - - - IS THERE A BETTER
WAY?
THANKS SO MUCH--
Jules