I have 2 spreadsheets with various column. I would like to see if it's
possible tos et up a formula that will:

1. Look at each number in a specified column in sheet 1.
2. Attempt to find that same value somewhere in a specified column in sheet 2
3. If it doesn't find that number in sheet 2, it woud either highlight the
value in sheet 2, or put a "no" in another column also in sheet 1.
4. Repeat this for each number in sheet 1.