Ok, I'll start over and see if it makes sense! I am creating a template to track project status. If their project isn't on schedule they will enter why and steps they are taking in cell E10. If there is a plan in place to get back on schedule the project would be yellow, if not, it is red. I want cell H2 to be filled with Green, Red or Yellow based on the text entered in E10.
Something that would work (if I could figure it out) would be to have the user type "red" or "yellow" before their explanation and create CF to look for those words to fill the cell appropriatley. (again, if nothing is entered, it will be green - that I can figure out).
I hope that makes sense as I'm not sure how to post a copy of the worksheet, and thanks for your help!