Conditional Formatting with Drop Down List

Dear All

how are you

Looking for help to solve Conditional Formatting function with drop down list.

When i change the Text of Drop down list ( cell : E2). color of Rows ( B2 : B8) is changing according to conditional formatting as i given. but color is changing in all rows not only in the row the that contain specific text shows in drop down list.

i like to make conditional formatting

change the only color of cells that contains only the specific text which i selected in drop down list.

Eg :

if i select drop down list ( E2) as Apple.... the select the rows which contain " Apple and only change the color of rows with GREEN that contains " Apple "

if it is Mango,.... the select the rows which contain " Mango and only change the color of rows with BLUE that contains " Apple "


File attached.
thanks

Sir

Thanks for your reply,,,when i am changing the drop list, its selecting all cells, instead of selecting specific text.........

You provide me the result wat i am looking for ......... Thanks n best of luck

interesting