xxxxxxxxxx
# Basic syntax:
=NOT(ISERROR(VLOOKUP(cell, lookup:range, 1, FALSE)))
# Where:
# - cell is the cell whose contents you want to look for in the column
# - lookup:range is the range for the column you are searching
# - 1 is the column number from which the matching value should be returned
# - FALSE requires that the cell is an exact match
# - NOT(ISERROR()) returns TRUE when the cell is found in the lookup:range
# Note, for formatting, use this formula in Conditional Formatting with Rule
# Type=Formula