Conditional Formating based on another cells value containing text and digits

Hello-- Using Excel 2007---2 questions--

1st --I have a column of cells (column B) containing text and two digit numbers in the same cell. I want the column next to it (column A) to have a conditional format based on whether that 2nd column has a number within a specific range. Meaning if it has a number between 10 and 19 the first column will be green, if between 20 and 29 it will be red, if it has a value between 30 and 40 it is a blue.

2nd--Is it possible to have the rule skip a number if it is followed by the word "egg" and only read the 2nd number for the conditional formatting rule?

Here are some examples of the text and number in the second column.

3 Split 15 Blast-(Column A Should be Green)
4 Right 16 Blast-(Column A Should be Green)
5 Split 23 Egg 16 Dive-(Column A Should be Green)
6 Split 38 Egg Fly 23 Dive-(Column A Should be Red)
7 Split 22 Dive 37 Egg-(Column A Should be Red)
8 Split 33 Dive 28 Egg-(Column A Should be Blue)
9 Split 33 Egg 28 Around-(Column A Should be Red)
10 Twins R 37 Egg Fly 24 Dive-(Column A Should be Red)
11 Split 23 Egg 30-R Flat-(Column A Should be Blue)

Is this possible

A few of those lines have more than one set of words and numbers..

Which one matters?

I have 9 minutes. We can do this!

So "Split 38 Egg Fly 23" has 2 words and 2 sets of number. It is Red because 23 is in the red range. It could also be blue for having a number between 30 and 40 though.

"Split 22 Dive 37 Egg" Also has 2 words and 2 sets of numbers. This one is also red, but the 2nd set of numbers is the one putting it in that category

Totally doable it seems.

Totally solved it and crashed Excel. Let me recreate.

So depressing. It's huge.

Edit: Totally missed half the formula.

Condition 1:
=AND(SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)>=10,
SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)<=19)

Condition 2:
=AND(SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)>=20,
SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)<=29)

Condition 3:
=AND(SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)>=30,
SUMPRODUCT(MID(0&IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),LARGE(INDEX(ISNUMBER(--MID(IFERROR(LEFT(B6,SEARCH(" Egg",B6)-4),B6)&IFERROR(MID(B6,SEARCH(" Egg",B6)+4,99),""),ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)<=40)

Attached example, because this got crazy complicated. This is how I like to finish a day.