Using VBA to highlight highest value cells - but with a difference...

[Mel Smith]

I am trying to write a macro that will highlight the highest value(s) in a range DB4:DB28 but I am struggling to ignore the values in brackets. An example of data is:
1(2), 2(4), 1(2), 3(6), 2(4), 1(2), 3(6), 2(4). I would want the two cells with 3(6) to be highlighted. I would like to use the colour: RGB(255, 255, 0).

Any ideas, please?

Mel

 

[Georgiboy]

How about conditional formatting?

Book1
	DB
4	1(2)
5	2(4)
6	1(2)
7	3(6)
8	2(4)
9	1(2)
10	3(6)
11	2(4)
12	1(2)
13	2(4)
14	1(2)
15	3(6)
16	1(2)
17	2(4)
18	1(2)
19	3(6)
20	1(2)
21	2(4)
22	1(2)
23	3(6)
24	1(2)
25	2(4)
26	1(2)
27	3(6)
28	1(2)
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
DB4:DB28	Expression	=--TEXTBEFORE(DB4,"(")=MAX(--TEXTBEFORE($DB$4:$DB$28,"("))	text	NO

 

[Mel Smith]

Thsnks, Georgieboy, I never even considered that.

Mel