Conditional Formatting (2 Viewers)

kitty77

Registered User.
Local time
Today, 07:46
Joined
May 27, 2019
Messages
716
I'm using conditional formatting on a report. I'm trying to bold font if it does not equal "#1" or "#2"
It works if I only use one but not with arguments.

[NewLineDesc]<>"#1" (this works)

[NewLineDesc]<>"#1" Or "#2" (this does not work)

Thanks.
 
You may need to create a new condition for <>"#2". The OR operator may not be recognized in conditional formatting.
 
@xavier.batlle 's suggestion in Post #3 will not work either (both "#1" and "#2" will be returned since they satisfy the other half of the expression)- @XPS35 has the solution in Post #6.

@DHookom provides the cleanest solution in Post #4

Your options are:
Code:
([NewLineDesc] = "#1" Or [NewLineDesc] = "#2") = False

[NewLineDesc] <> "#1" And [NewLineDesc] <> "#2"

[NewLineDesc] Not In ("#1", "#2")
 

Users who are viewing this thread

Back
Top Bottom