Conditional Format for Cell Containing a specific character and less than 50%

[Swissmiss]

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]+A (66.05%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]F (1.85%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl65, width: 86"]A (25.83%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]B (6.64%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]G (11.07%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 87"]
<tbody>[TR]
[TD="class: xl65, width: 87"]+G (66.79%)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]+F (47.23%)[/TD]
[TD]A (4.8%)[/TD]
[TD]B (30.63%)[/TD]
[/TR]
</tbody>[/TABLE]


I have a huge spreadsheet with test data. I want to conditionally format all cells that contain a + and are less than 50%. Anyone know the formula for that? So I would be color coding the cells that are the right answer, but less than 50% of students chose that answer.

Thanks!

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]+A (66.05%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]B (6.64%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td="bgcolor:#FFFF00"]+F (47.23%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]F (1.85%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]G (11.07%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]A (4.8%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]A (25.83%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]+G (66.79%)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]B (30.63%)[/td][/tr]
[/table]

The CF rule is

=FIND("+", A1) * (--LEFT(MID(A1, FIND("(", A1) + 1, 10), LEN(MID(A1, FIND("(", A1) + 1, 10)) - 1) < 0.5)

 

[Swissmiss]

That worked perfectly!!! Thank you so much!

 

[shg]

You're welcome.