I am importing information from another app to excel. I have a column (k)
which has Red, Green or Yellow in some of the cells. For these cell only
that have the text I would like to replace the text with the appropriate
stoplight. Can anyone please help me?
Thanks in advance for your help.