CODEWITHSUNDEEP
ms-accessreporting
Avraham
Avraham

Reputation: 45

access: conditional formatting on report

I have a report example two fields [Name1], [Name2]

what is the expression for conditional formatting on name1 to highlight when not = to name2?

Is it:

<>[Name2]

it is not working :(

Upvotes: 1

Views: 1285

Answers (1)

DJ.
DJ.

Reputation: 16267

You can do it two ways:

Select "Field Value", "Not Equal" and then type in "[Name2]"

or

Select "Expression" and type in "[Name1]<>[Name2]"

Upvotes: 3

Related Questions