I have three columns for product approval. In each one, you can select either
'Approved', 'Rejected', or 'Dropped'. For example, sometimes a product will
be rejected in the first column and then approved on the second attempt, so
then the 2nd column will show as 'Approved'.

I want to be able then have it auto-insert a symbol based on the selection
chosen the most recent approval column as follows:
Approved - check mark
Rejected- big 'X'
Dropped- down arrow
Note: if the approval column has no entries in it, I would like the cell to
be blank (no symbol)

Is there a way to do this? Does Excel work with symbols in this way?
Thanks!