Conditional formatting and percentage in access form?

[aonsu209]

Dear all,

I have really annoying issue with condition formatting. Im trying to have value green below 100% and red above, but check below.




I try only 100 as number, formatting 100 to % and still nothing, I'm sure will be something simple, but what?
Thank you in advance.
Tommy

[JoeM]

What is the formula behind Used2?
Note that if it is returning a numeric value, then you do not want to use the FORMAT function in your Conditional Formatting formula, as FORMAT returns a Text value, not a Numeric one.

You would just want to use:
[Used2] < 100%
or
[Used2] < 1

[aonsu209]

Thanks for the reply, I thought same way and I tried with 1 or 100 but same, it is not working.

The formula behind is:
=IIf([TotalPeriod2]=Null And [Amount_Request_Period_2]=Null,Null,IIf([Amount_Request_Period_2]=0,0,Format(([TotalPeriod2]/[Amount_Request_Period_2]),"0%")))
So it is returning to percentage.

[JoeM]

=IIf([TotalPeriod2]=Null And [Amount_Request_Period_2]=Null,Null,IIf([Amount_Request_Period_2]=0,0,Format(([TotalPeriod2]/[Amount_Request_Period_2]),"0%")))
So it is returning to percentage.

Same issue as I mentioned with the Conditional Formatting rule. Do NOT use the FORMAT function, it returns text and NOT a numeric value.
Remove that so you are returning a numeric value.
You can change the Format property of the Text Box to return a percentage format (don't do it in the formula).

[aonsu209]

Thank you!