Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Audit Trail | Excel Discussion (Misc queries) | |||
Help with time audit | Excel Discussion (Misc queries) | |||
Audit Trail | Excel Discussion (Misc queries) | |||
change audit | Excel Programming | |||
Model Audit | Excel Programming |