Conditional Formating not co-operating (1 Viewer)

access2010

Registered User.
Local time
Today, 01:34
Joined
Dec 26, 2009
Messages
1,019
Could we please receive your suggestion on how to correct our colour formatting problem?
if an Equity will be increasing in value the prefix is = "Up"
Such as; Up_Upgrades / UP_Undervalued / Up_Overweight

If an Equity will be Decreasing in value the prefix is = Dn”
Such as; Dn_Downgraded / Dn_NewLow / Dn_Sell

Please help us find an answer to why these items are red?
Such as; Organic Growth / Neuttral / Hold

Thank you.
Nicole
 

Attachments

  • 1604338303907.png
    1604338303907.png
    33.5 KB · Views: 107

theDBguy

I’m here to help
Staff member
Local time
Today, 01:34
Joined
Oct 29, 2018
Messages
21,358
I think you would want to use Expression Is rather than Value Is, since you're talking about checking for a prefix with probably a Like expression.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 01:34
Joined
Aug 30, 2003
Messages
36,118
You're using "greater than..." with a text value, which will give unexpected results. My guess is you want Expression Is with something like

[FieldName] Like "Up*"
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 01:34
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom