I'm using the following iif statement to compare 2 different rows using the conditional format to change the color to Red if the field is different. I've been using this method on the same report and some fields it works and some fields it doesn't work.
=iif(instr(Fields!Prev_AltAcctTypeB.Value, Fields!After_AltAcctTypeB.Value)>0,"Transparent",'Red")
Is there a different way to display the differences in fields or a trick to correct this? As you can see from this picture below, there's no differences yet it shows the conditional format as being different.