Unbelievable, but once in a while Excel can spoil your day when you "just want to have a quick analysis" of your data. Having all similarly looking but totally different FIND, SEARCH, LOOKUP, etc methods just does not help. So how can you find whether a value exists in a selection of cells?
Lyrics apart, once again I was building up a cross-reference trying to find mentioning of a value in a selection of cells. After all it appeared to be pretty simple. If you know what you’re looking for:
Excel search text in cells
This will give you "#N/A" when no value of A1 is found in the range of B10:B100 or a number when a value is found. If you want it to be a bit more ‘boolean’ you can use the following formula
so that the result is TRUE or FALSE. Add some conditional formatting with red/green and it will give you a good start for something comprehensible.