What I need to do is when the user enters certain values in a cell, they get
a flag to indicate that the item is on a list. We enter a lot of values in
our Serial Number spreadsheet. There are certain values though, that need to
get the users attention. I know how to do it directly from the cell, but
that is too limited and awkward to change as these values will need to be
updated from time to time. For instance, if the user enters "12345678" he
will get a message, "This product requires an FAI!" I don't care how that
works, i.e., popup or something in an adjacent cell. Any ideas how to do
that?

Thanks,
Bryan