I am creating an automatic college degree check worksheet. One tab has a list
of courses in each quarter and another tab has a list of required classes for
graduation. I would like to setup a formula that would find if "Organic
Chemistry B" is present in the classes tab and return a value that I could
use conditional formatting on.

I have tried using SEARCH and FIND, but I have not been sucessful. I
understand the conditional formatting part of the problem, but I do not
understand how to create a search function that will return some sort of
number.

Any ideas?

Thanks!

- Ryan