Need help!!!!

Let us say everytime I enter "YES" in column B in the same row I want to
insert the following formula:
=IF(B4="Yes",C4&E4,"") and highlith it in green.

How can I do it?
Chuck