Conditional Formatting % Percent or $ Dollar (1 Viewer)

access2010

Registered User.
Local time
Yesterday, 23:18
Joined
Dec 26, 2009
Messages
810
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

AWF VIP
Local time
Today, 07:18
Joined
Jul 26, 2013
Messages
9,074
5 % would be stored as .05 normally, does that help if they are both in the same field?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:18
Joined
May 7, 2009
Messages
15,048
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")
 

access2010

Registered User.
Local time
Yesterday, 23:18
Joined
Dec 26, 2009
Messages
810
Thank you, arnelgp for your suggestion.

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

access2010

Registered User.
Local time
Yesterday, 23:18
Joined
Dec 26, 2009
Messages
810
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
 

Users who are viewing this thread

Top Bottom