Conditional formating where there are 2 values in a cell

Godders199

Active Member
Joined
Mar 2, 2017
Messages
313
Office Version
  1. 2013
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

11(78.6%)2(14.3%)1(7.1%)
<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> </tbody>

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.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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.
 
Last edited:
Upvote 0
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:
Code:
=(TRIM(MID(SUBSTITUTE(SUBSTITUTE(D1,"(",REPT(" ",100)),")",REPT(" ",100)),100,10))*1)>10%
 
Upvote 0

Forum statistics

Threads
1,212,933
Messages
6,110,757
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top