change audit
 

Thank you very much. I can't wait to show this to my Gary and test it on
some of my backlog.

Thanks again!!
--
Gary's Student


"Gary's Student" wrote:

I am doing change audits and need a function to determine if two cells are
identical
Example: =SomeFunction(A1,B2) returns 1 if A1 and B2 are identical,
otherwise 0.

A1 and B2 are not identical if:

1. they contain different values
2. one contains a value, the other a formula
3. one contains a comment, the other not
4. the background colors differ
5. text strings contained in the cells are different
6. text alignments are different
7. fonts are different
8. borders are different

Thanks in advance for your help

--
Gary's Student