This is what I'm trying to accomplish: when the word "completed" appears
in column D I want the that ROW (lets say a1 to T1) to be highlighted in
yellow,if another word appears on that cell then highlighted in green

I tried conditional formatting - Cell value is - and of course it only
highlights one cell. I also tried conditional formatting using" formula is"
and that is where I'm having dificulties. 'm stuck... someone help me please
thanks