Special characters added to a cell based on a condtion

  I have a list of clients that are considered active until they pass away, at which time we categorize them as deceased. Upon this happening, I would like a special character to be added onto their...