excel - Conditional formatting depending on cell content (combination of a cell reference followed by specific text string) -

i have range of cells. want format of cells in range contain text string.

the problem is, text string constructed in 2 parts. first part reference cell can contain different text strings (the cell referencing cell, drop down list several choices). second part actual defined text string.

in example, cell g2 contains string "referenced cell &".

in range b2:b11, formula is:

=if(and($e$2>=1,$e$2<=10),$g$2&" text string 1",if(and($e$2>=11,$e$2<=20),$g$2&" text string 2","")) 

so:

• if cell e2 contains value between 1 , 10, cells in range contain text string in cell g2 followed text string " text string 1".

• if cell e2 contains value between 11 , 20, cells in range contain text string in cell g2 followed text string " text string 2".

i want format range differently each of these outcomes.

• if resulting string "referenced cell & text string 1" cell red.
• if resulting string "referenced cell & text string 2" cell green.

how can perform conditional formatting on cell when value created in way?

an alternative approach:

where 2 rules (assuming integers):

green =and(e$2>10,e$2<21)
red =and(e$2>0,e$2<11)