Change colour of a row with respect to Text/colour of a adjacent cell

Hello There,

I have been going crazy with this issue. I'm a beginner with the VB and Formulas. I want to color rows with regard to either the color in the cell on the last column/Text of that cell.
I've enclosed the excel sheet herewith.

Thanks much in advance.