AnsweredAssumed Answered

Conditional formatting issue

Question asked by ijontichy on Aug 22, 2012
Latest reply on Aug 23, 2012 by philmodjunk


Conditional formatting issue


I have a fairly simple conditional formatting formula such that if Table A::field A's contents do not equal Table B::field A's contents, then turn the box red and the text yellow.   The relationship between tables is a simple ID.


For reasons I cannot discern, in a couple of records, the conditional formatting is triggering EVEN WHEN the contents of both fields are exactly the same.   I even cut and pasted the information into both fields so I would know that it is identical.   And then I cut and pasted the shared simple ID that connects the two table.


Again, most of my records are working just fine.