Conditional Formatting question

[katekaew]

I use this to calculate my percentage.
PerCent: IIf(IsNull(Sum([TotalEachOption]/[TotalCount])),"0.0%",Format((Sum([TotalEachOption]/[TotalCount])),"0.0%;-0.0%;0%"))

I get the result but it's a text data type. I try to use Conditioanl Formatting if > 70% is green and < 30% is red but it's mixed up between "7%" and 70% and 7%. Both percentage get the same color.

How to solve this problem?

Thanks!

 

[katekaew]

I don't use format(). I calculate and make the table then change the datatype of my fields from text to double and use format as percentage instead. Now, I can use conditional formatting on the menu bar.