comparing cells

Giganews Newsgroups
Subject: comparing cells
Posted by:  Nooby (stwils…
Date: 18 May 2006

I need to compare the values in two cells and set a flag (preferably
color the cell red) if they are different. There are too many to do
visually, so I would like to automate the process.  Can a macro be
written to check differences? What if I want an intelligent comparison,
such as that I want to ignore excess spaces, but not different
values...? I may also want to skip some cell comparison based on the
value in a third cell..... .This third cell may have a Y or N for
compare, or not.
How should I approach this? Any help at all would be greatly