Conditional Formatting (2 Viewers)

[kitty77]

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.

 

[LarryE]

You may need to create a new condition for <>"#2". The OR operator may not be recognized in conditional formatting.

 

[xavier.batlle]

You may need to create a new condition for <>"#2". The OR operator may not be recognized in conditional formatting.

Try:
[NewLineDesc]<>"#1" Or [NewLineDesc]<>"#2"

 

[DHookom]

You could also try:
[NewLineDesc] Not In ("#1", "#2")

 

[CarlettoFed]

Please try attaching a sample file.

 

[XPS35]

Try:
[NewLineDesc]<>"#1" AND [NewLineDesc]<>"#2"

 

[cheekybuddha]

@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:

([NewLineDesc] = "#1" Or [NewLineDesc] = "#2") = False

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

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