Conditional Formatting % Percent or $ Dollar

[access2010]

I am trying to have the conditional formatting background colours change
IF 5 % (with the percent sign) the colour would be Green
if $5 (with the Dollar sign) the colour would be Orange

The database is Access 2003 and t5he field is Text.

Your suggestion will be appreciated.

Nicole

 

[Minty]

5 % would be stored as .05 normally, does that help if they are both in the same field?

 

[arnelgp]

does that help if they are both in the same field?

first condition (green)
Expression: ([fieldname] & "" = "5 %") Or ([fieldname] & "" = "5%")

second (orange)
Expression: ([fieldname] & "" = "$5") Or ([fieldname] & "" = "$ 5")

 

[arnelgp]

t5he field is Text

 

[access2010]

Thank you, arnelgp for your suggestion.

WE have found that, $ 5 and % 5 is working for us

 

[access2010]

Thank you, arnelgp for your suggestion.

WE have found that, $ 5 and % 5 is working for us

Field Value is // greater than // %
Field Value is // greater than // $

We do appreciate your suggestion.

Crystal