Visual Indication of Matching Text Boxes

[brobertson89]

Hi everyone!



This seems simple but I have no idea how to do this. I want to indicate whether any of the text boxes on the right hand side are the same as those on the left hand side. Basically for this form you select a customer and it tells you what courses that customer requires for your technician to have completed before they can work with that customer. Then on the right hand side you select a technician and it shows you what courses they have done. When they are both selected I want there to be a visual indication of how many of the courses that the customer requires does the technician have. See picture attached for example.

Cheers

[June7]

This is already marked solved - is it?

[brobertson89]

hey June7

Yeah it is solved, I used conditional formatting, the only issue I have now is that when the there is a blank text box on both sides it still highlights it as they are both matching. I created a work around by putting a dash in the blank company course field. If you have any better ideas then I am all ears?

[June7]

Maybe additional criteria in expression for highlight:

Not IsNull(Textbox1) AND Not IsNull(Textbox2)