Does anyone out there know a simpleway to compare the values in two
different columns on an Excel spreadhseet and pick out all of the
cells in the first number that have a value that the second column
doesn't have? Thanks.

One way is to use conditional formatting.

Suppose the first column is A and the second is B.

Select A1 and use
Format Conditional formatting Formula is
Then put for the formula
=COUNTIF(B:B, A1)=0
Then click
Format Patterns
And choose a background color of your choice, followed by clicking OK and
OK again.

Finally, with A1 still selected, click the paintbrush and then spread the
paint down the list of values in column A; this paints the conditional
formatting onto those cells.