2 Replies Latest reply on Mar 25, 2015 7:42 AM by ryan.george19

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

    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.