Color Part of Cell

[poikl]

I have a Vlookup formula (which you helped me build)that reviews a column of item #s and answers one of the following: Part approved;Product approved;Part approved and Product approved;Part rejected Product approved;Part special Product approved; etc many other compilations.
Now I would like that ONLY the word "rejcted" be Colorer RED,"special" Colored Blue, etc. is this possible??

 

[poikl]

My Vlookup brings up one of the following results:
1)Product? YES,Part? no,Special? YES
2)Product? no,Part? Yes,Special? no
it can be all YES, all no or one or two YES etc.
Now what I need is whenever there is a YES result then only the word YES should be color Red.
Could you please give me the exact formula to make this happen?