Conditional formating where there are 2 values in a cell

[Godders199]

Hello, before i start rebuilding a spreadsheet to split values into two cells, is there anyway to conditionally format a cell, based on one of the values contained in it. for example

[TABLE="width: 209"]
<colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;"> <col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <tbody>[TR]
[TD="width: 74, bgcolor: #E4DFEC"]11(78.6%)[/TD]
[TD="width: 115, bgcolor: #E4DFEC"]2(14.3%)[/TD]
[TD="width: 89, bgcolor: #E4DFEC"]1(7.1%)[/TD]
[/TR]
</tbody>[/TABLE]

the formula in the cell, counts occurance an then calculates the percentage.

all am looking to do is say if cell %> X then format red for example.

If not i will just split the formula into 2 cells and format both.

 

[Fluff]

Maybe something like
=SUBSTITUTE(REPLACE(A4,1,FIND("(",A4),""),")","")+0>0.2

But it maybe be easier to format the cells by looking at the original cells.

 

[Joe4]

Let's say that your entry is in cell D1, and you want to highlight it if it is greater than 10%.
Then you can use this Conditional Formatting formula:

=(TRIM(MID(SUBSTITUTE(SUBSTITUTE(D1,"(",REPT(" ",100)),")",REPT(" ",100)),100,10))*1)>10%

 

[Godders199]

thanks both, will give it a go