if condition to use the same formula with two cells and to enter text

Hi all
I want a formula or a macro which will help me in my scenario

I have two columns Enter and Status
If I enter Yes in the column Enter then the corresponding status column should be fill with green color (we can use conditional formatting)
If I enter No in the column Enter then the corresponding status column should be fill with Red color and the main part is, if the cell in column Enter is No then all the below cells should also be No automatically. If I some where enter the data as yes then the below cells should change to Yes and the corresponding cell to be filled with the appropriate color.

any help is appreciated

hi kishoremcp, is the attached file what you need? you just have to overwrite the formulas to make the ones below all turn to the same colour