Lookup value with format rule?

I have information entered in one table, I want to lookup a value from this table and see if it is present in another table. If it is NOT present, I want to execute a format rule that color code it for recognition that it is NOT in that table used for the Lookup. How to?

0 9 214
  • UX
9 REPLIES 9
Top Labels in this Space