AnsweredAssumed Answered

Conditional formatting that compares data in one field to data in another field

Question asked by ryan.george19 on Mar 24, 2015
Latest reply on Mar 25, 2015 by ryan.george19

Title

Conditional formatting that compares data in one field to data in another field

Post

I am looking for a way to use conditional formatting to alert the user that the entered data doesn't match the date used to populate the dropdown data.

We import data into a import database.  Once imported the data is reviewed and if something is wrong in the field, the user has to click on the field and select the correct data (usually a spelling error) from the dropdown list. The said dropdown list is data pulled from a different database of data.

Example:

"Vehicle Make" (R_Vehicle_Make) imported into Import Database = FORDD

Dropdown Data provided by the "Vehicle Make" (V_Make) field found in the Vehicle Database = FORD

Would like the "Vehicle Make" (R_Vehicle_Make) field in the Import Database to have a fill color to alert the user the imported data doesn't match the "Vehicle Make" (V_Make) data.

Hope that makes sense?  If not please let me know.

Outcomes