Although, the conditional formatting with cell shading
is much better than the words, what I wish to do is for every cell that
contains green insert a green stoplight, for red a red stoplight and for
yellow a yellow stoplight. For cells with no data remain empty.


"John Bundy" wrote:

I think what your asking is that if the cell says green then the cells color
is green and so on? if so the use Format-Conditional Formatting change the
second box to Equal To then put green in the third and click the Format...
button and change pattern to green. do the same for the rest.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"CB" wrote in message
...
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.