I would like to have one or more cells change cells if a cell below = a
certain thing.

Would it be possible in a VLOOKUP to assign different cells in the column
different colors that would be linked to the cells above the VLOOKUP cell.