Conditional formatting that compares data in one field to data in another field
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.
"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.