string based Conditional formatting

[Eowyn]

Hello,
          I have the below fields in a report and would like to highlight the values in the Server_name column where the server Name is not the same as its corresponding value in FQ_HOST column.
OS Name| Server Name| FQ_HOST| FQ_HOST2

I created a variable which evaluates whether ( [Query].[Server Name] not like [Query].[FQ_HOST] ) and tried to apply that to the Server Name column. However on running the report every entry in the Server Name column was formatted which is wrong. Can someone please guide me on how to go about with the conditional formatting in this scenario.

Thanks.

[Lynn]

Hello,
          I have the below fields in a report and would like to highlight the values in the Server_name column where the server Name is not the same as its corresponding value in FQ_HOST column.
OS Name| Server Name| FQ_HOST| FQ_HOST2

I created a variable which evaluates whether ( [Query].[Server Name] not like [Query].[FQ_HOST] ) and tried to apply that to the Server Name column. However on running the report every entry in the Server Name column was formatted which is wrong. Can someone please guide me on how to go about with the conditional formatting in this scenario.

Thanks.

I would click on the server name column and then apply an advanced conditional style using the expression
[Query].[Server Name] <> [Query].[FQ_HOST]
setting the style to whatever you like for that situation.