Conditional formatting not followed by map bubble?

[olimilo]

I have the following conditional formatting ruleset:

When I apply the rule, it doesn't seem to get the 46%-69% rule properly. Spain, China and US should be in yellow but instead are shown in red:

SCORE is formatted as Number type in PQ and as Percentage once loaded:

ID		Facility Country	SCORE
1		United Kingdom	86%
2		United States of America	80%
3		United States of America	63%
4		Spain		69%
5		United States of America	48%
6		United States of America	58%
7		China		82%
8		United Kingdom	72%
9		China		66%
10		Ireland		87%
11		United Kingdom	73%
12		Philippines	67%
13		Philippines	98%
14		Philippines	101%
15		China		40%
16		China		79%
17		China		79%
18		Philippines	57%
19		United Kingdom	98%
20		China		51%

[maruthisp]

Hi @olimilo,

Could you please try below steps:
To make your map bubbles accept the 46 - 69% rule, switch your conditional formatting thresholds to use decimal fractions (e.g. 0.46–0.69) and treat the field as a Number, not a Percent.

By switching your thresholds to 0.46–0.69 and formatting the column as a Number, Spain, China and the U.S. will now correctly show up in yellow. Just adjust the formatting settings will help to solve.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X 

[Ritaf1983 · Accepted solution]

Hi @olimilo 
Modify formating option to Decimal Fraction like 0.75 ,1 etc...  instead of percent , and celect "Number" instead of "Percent"
it should work.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.